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)