Frappe.db.sql how its work?!

AliMJawad · January 2, 2018, 9:54am

Hi All ,
happy new year

I don’t know why sometimes frappe.db.sql work and others not work

balance = frappe.db.sql(“”“select sum(credit)-sum(debit) from tabGL Entry where party = %s”“”, doc.customer)

when I run sql query in mariaDB it’s work 100% !

also I do copy past an do some changes fields, tables not work correctly but it’s work in mariaDB

best regards,
thanks

tundebabzy · January 2, 2018, 10:48am

Hi.
What do you mean by not working. Does it return no results or it returns an error? If it’s an error, what is the error?

magic-overflow · January 2, 2018, 11:21am

can you try?
balance = frappe.db.sql(“”“select sum(credit) - sum(debit) from tabGL Entry where party = ‘{0}’”“”.format(doc.customer))

Edit:
I tried your code, it works fine.

AliMJawad · January 3, 2018, 5:41am

its work when I add. [0][0] at the end of frappe.db.sql