Odoo Ajuda


1 Resposta

patrick Holanda


| 5 4 9
Baarn, Holanda
patrick Holanda
03/07/13 10:51

The issue is that ref expects a string. In SQL, strings need to be surrounded by single quotes ( ' )

So the following (add a ' before and after %s) should do the trick:

move_obj = self.pool.get('account.move.line')
cr.execute("SELECT debit,credit FROM account_move_line WHERE  ref = '%s'",(move_id,))

You do not get string errors, becausew you start and end with a double quote ( " ), which does NOT end with a single quote ( ' ).

Faça uma Pergunta
Keep Informed
0 seguidor (es)
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.

Odoo Training Center

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

Test it now