• From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,181

Re: Grab Data of individual Accounts From Database

@apmuthu, its a mandatory parameter to get_balance function.  so he has to add it without checking whether the account code null or not.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Grab Data of individual Accounts From Database

The issue here is that the alias of the table in addressing the field may be required in some MySQL versions. Therefore the field "account" referred to in the existing sql was sought by you to be replaced by "trans.account" which is okay. The NULL check is still retained.

apmuthu's Website