This question has been flagged
2 Replies
17049 Views

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

Avatar
Discard
Best Answer

Hi,,

cr.execute('select id from table_name where your_field=%s ', (patamerter1,))

Thanks

Avatar
Discard
Best Answer

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))
Avatar
Discard