Se rendre au contenu
Menu
Cette question a été signalée
3 Réponses
12749 Vues

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  "

 

Avatar
Ignorer
Meilleure réponse

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)

 

Avatar
Ignorer
Auteur

Thank you very much. This is the best answer

Meilleure réponse

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))

Avatar
Ignorer
Meilleure réponse

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

Avatar
Ignorer
Publications associées Réponses Vues Activité
0
sept. 23
6288
1
juil. 20
5061
0
déc. 23
8191
0
mars 15
3305
0
mars 15
3531