i want to create 'select query' in cr.execte with string parameter and how to pass the parameter to return statement in python for openerp
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
2
Replies
17428
Views
Hi,,
cr.execute('select id from table_name where your_field=%s ', (patamerter1,))
Thanks
or in using self.env.cr.execute, you can do
self.env.cr.execute("DELETE from account_invoice_summary where invoice_id = %d" % (self.id))Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up