How to button object use?

Hello Shankar,

It is very easy. You have to define separate two method which calculate the answer and write this answer in to ans field of am.calculator object .

Hope this will help you.
Thanks.

Hello Vra(openerp),

   I am new to openerp object, I tried with following code, I fail to make addition of two field,

Case:1)

code in openerp Object:
    def addition(self,cr,uid,ids):
        _columns['ans'] = float (_columns['aVal']) + float(_columns['bVal'])

Error:

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 244, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 73, in __call__
    return getattr(self, method)(*params)
  File "/usr/lib/python2.5/site-packages/openerp-server/service/web_services.py", line 583, in execute
    res = service.execute(db, uid, object, method, *args)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 59, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 118, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 110, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/orm.py", line 1279, in fields_view_get
    xarch, xfields = self.__view_look_dom_arch(cr, user, doc, view_id, context=context)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/orm.py", line 1084, in __view_look_dom_arch
    cr.execute('select name, model from ir_ui_view where (id=%s or inherit_id=%s) and arch like %s', (view_id, view_id, '%%%s%%' % field))
  File "/usr/lib/python2.5/site-packages/openerp-server/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/python2.5/site-packages/openerp-server/sql_db.py", line 120, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = boolean
LINE 1: select name, model from ir_ui_view where (id=false or inheri...
                                                    ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
-----------------------------------------------------------------------------------------------------------------------------
Case :2)
code In openerp Object:

    def addition1(self,cr,uid,ids,c, d):
        print "value of a: ", c, "value of b: ", d
 return {'value':{'ans': c+d}}

code In XML file:
       <field name="ans" on_change= "addition1(aVal,bVal)"/>

Error:
Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 244, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 73, in __call__
    return getattr(self, method)(*params)
  File "/usr/lib/python2.5/site-packages/openerp-server/service/web_services.py", line 583, in execute
    res = service.execute(db, uid, object, method, *args)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 59, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 118, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 110, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/orm.py", line 2084, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/orm.py", line 2138, in _read_flat
    self._order), sub_ids)
  File "/usr/lib/python2.5/site-packages/openerp-server/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/python2.5/site-packages/openerp-server/sql_db.py", line 120, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column "ans" does not exist
LINE 1: SELECT "aVal","bVal","ans",COALESCE(write_date, create_date,...

I need more help.
Shankar

Hello Shankar,

You need to define the method with same name of button which you did assign in the view.

    def addition(self, cr, uid, ids, context={}):
        if ids:
            obj = self.browse(cr, uid, ids, context)
            sum = obj[0].aVal + obj[0].bVal
            self.write(cr, uid, ids, {'ans': sum})
        return True
 Similarly for subtractions.

Hope this will help you.

Thanks.

Hello vra,

  I use the given code.Test module on local system and remote sever it give me same above error message is:

ProgrammingError: operator does not exist: integer = boolean
LINE 1: select name, model from ir_ui_view where (id=false or inheri...
                                                    ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

I don't get what is twist in the code.
Shankar

Hello Shankar,

There are so many example exist in tiny existing code you can search and understand.
You can use workflow function also.
Like invoice workflow for example.

Thanks.

Hello vra,

   I will try tomorrow u suggested tricks.

   I observed in OpenERP data on the view form get saved then any required operation we do.
ex.
   on "purchase.order.form" view we fill the data for the field "Purchase Order Lines" if we press save button Or Refresh button Or Compute button then (Untaxed amount, Taxes, Total ) get calculate respective value and fill on the form

I think ,In mine case data in the "aVal" and "bVal" field only on view form , if click on add button call goes for python object, but value on form do not get for operation in object.

Is this my interpretation correct or wrong I don't know?

Shankar

Thanks vra (openerp), that solved my question.