How can i write update query in a function?

Question

In the below fuction I want to update  "account_bank_statement" table field balance_end_real with the vale balance_end. i.e "update account.bank.statement set balance_end_real=balance_end where id=ids"

"def _compute_difference(self, cr, uid, ids, fieldnames, args, context=None):
result =  dict.fromkeys(ids, 0.0)

for obj in self.browse(cr, uid, ids, context=context):

result[obj.id] = obj.balance_end_real - obj.balance_end

return result  "

Ben Bernard · Accepted Answer

It seems that balance_end_real field already in the same model (or inherited) with the method you defined. In that case you don't need to use update sql manually, just use write method.

self.write(cr, uid, ids, {'balance_end_real': obj.balance_end}, context=context)

Nehal · Answer

Hi,

You can use "cr.execute" to update record based on id. Refer the following example:

cr.execute('update account_period set state=%s where id=%s', (mode, id))

Deepa Venkatesh · Answer

Use "cr.execute" and update directly using sql update statement...

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
How can I display data from database in form view query	0 syysk. 23	6316
Insert query in odoo 13 Ratkaistu query	1 heinäk. 20	5078
ParseError: "duplicate key value violates unique constraint "res_groups_name_uniq"? query	0 jouluk. 23	8216
warehouse and location query query	0 maalisk. 15	3326
How to create a method that will display values from database to a selection type field? query	0 maalisk. 15	3553

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!