Odoo Help

0

how to create parameter in cr.execute in python for openerp

By
kalyan
on 4/17/14, 6:24 AM 6,972 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

1
Jagdish Panchal
On 4/17/14, 6:51 AM

Hi,,

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

Thanks

0
Fongoh Tayong
On 1/28/16, 8:07 AM

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

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)

Stats

Asked: 4/17/14, 6:24 AM
Seen: 6972 times
Last updated: 1/28/16, 8:07 AM