Problem on frappe.db.sql

Frappe Framework Customization
1

Hi All,

I need some simple help on frappe.db.sql.( i modify it from sales order.py ) Below is my code and the setting of two doctypes.:grinning:

image.png801×283 14.4 KB

image.png1164×651 38.5 KB

image.png1179×634 38.8 KB

2

@kenny

Always use tab as prefix for table name. So it should be tabtest_doctype2.

1 Like
3

thanks @Sangram. It worked like charm.