Ir al contenido
Menú
Se marcó esta pregunta
2 Respuestas
17997 Vistas

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
Descartar
Mejor respuesta

Hi,,

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

Thanks

Avatar
Descartar
Mejor respuesta

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
Descartar