In frappe sql is already connected. So, how do I execute sql commands in python.
Please provide me as example to execute the following command in frappe:
DELETE FROM ‘tabAdd to Orders’ WHERE selected =‘product-04’ in python
In frappe sql is already connected. So, how do I execute sql commands in python.
Please provide me as example to execute the following command in frappe:
DELETE FROM ‘tabAdd to Orders’ WHERE selected =‘product-04’ in python
use frappe.db.sql("sql_query")
Thank you that worked like a charm.