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
- Akuntansi
- Inventaris
- PoS
- Project
- MRP
Pertanyaan ini telah diberikan tanda
2
Replies
17971
Tampilan
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))Menikmati diskusi? Jangan hanya membaca, ikuti!
Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!
Daftar