Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I'm currently developing a function that can delete an order line with a click on a button and a SQL query.
My query has a syntax error but I'm inspiring myself with odoo's addons.
The error is this:
psycopg2.ProgrammingError: syntax error at or near "%" LINE 2: WHERE (product_id = %(product_id)s)AN...
And my query is this:
DELETE FROM sale_order_line WHERE (product_id = %(product_id)s)AND (order_id = %(order_id)s)
Hello
try will below code:
self._cr.execute("DELETE FROM sale_order_line WHERE product_id=%s AND order_id=%s", (product_id, order_id))
in above query you have pass the interger value of variable product_id and order_id
Oh okay I see the mistake
Thanks for the help
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
