as you can see it has 2 fields 1.) Shipping Address(char) which the user will input his address, 2.) Current (boolean), each address contains 'current' field wherein it is with a 'button'.. if the user clicks the button it will toggle the boolean field of a certain record to 'true'.. here is my xml (just a snippet, dont worry it has no defect)

here is the image to better appreciate : http://postimg.org/image/k0gjwlmcj/

</record>

as you can see i use type='object' (or am i wrong? ) because i will call a function which contains the query, im planning to make this function and add to .py file, unfortunately im not able to do that because the function is not finish yet.. can you help me? i want that when the button is pressed it will toggle the boolean variable to 'true' of that certain id.. how can i link this to the button i have made in the xml?

def set_current_addr(self,cr,uid,ids,name,arg,context=None):

res={} #is this necessary? i just saw it in other sites
cr.execute("""UPDATE si SET current='true' where id=ids;""")

return res #is this necessary? i just saw it in other sites

Please guide me so that i can continue my learning in odoo.

also is 'uid' in the function there the create_id i and the 'ids' the id n openerp?

Emipro Technologies Pvt. Ltd.

Hey ! I hope you got the answer from the below. If yes then please accept it. Thanks.

Emipro Technologies Pvt. Ltd.

Beste antwoord

Lakay,

It's so easy !

Your method should look like,

def set_current_addr(self,cr,uid,ids,name,arg,context=None):

self.write(cr,uid,ids,{'current':True},context=context)

return True

Here by calling write method it is itself applying update query and your current record will be updated. It is adviceable that don't write queries, instead of that use ORM functions. Write is one of the core methods of OpenERP framework. Still if you want to do by query then below is the code.

def set_current_addr(self,cr,uid,ids,name,arg,context=None):

cr.execute('UPDATE si SET current='true' where id=ids[0]")

return True

No need of res = {} and return res as per your code.

Hope this helps,

Emipro Technologies Pvt. Ltd.

in "ids" argument you will find the current record's id in "Array".

Lakay lakay

Auteur

Hi, itried your solution, but it gives me error ProgrammingError: column "ids" does not exist LINE 1: UPDATE si SET current='true' where id=ids[0] here is my code class si(osv.osv): def btnSet(self,cr,uid,ids,context=None): self.write(cr,uid,ids,{'current':True},context=context) cr.execute("UPDATE si SET current='true' where id=ids[0]") return True _name='si' _columns ={ 'addr':fields.char('Shipping Address',size=100,required=True), 'current':fields.boolean('Current'), } si()

Lakay lakay

Auteur

Thanks Hiren, I figured it out, so its easy to use ORM functions instead of querying! i learned it!! thanks!! this is my code def btnSet(self,cr,uid,ids,values,context=None): self.write(cr,uid,ids,{'current':'true'}) return True thanks man!!

Lakay lakay

Auteur

Emipro Technologies Pvt. Ltd.

This button will call the method name "btnSet" of the class "si". So, you have to defind one method with the name "btnSet" as like below.

def btnSet(self, cr, uid, ids, context=None):

#Perform your code This is comment.

self.write(cr,uid,ids, {'current':True}, context=context) #It will write the true value into 'current' field for the record on which button is pressed.

# you can write here more code as your requirement.

return True #You can return anything from here.

Lakay lakay

Auteur

thanks dude. i learned from Hiren that there is an alternative way (easier way) to modify data in database by using ORM functions such as write.. thanks for giving me solution on how to link the function in .py to button in .xml! thanks man!

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
Can you check a code of my module : filed. function function field	2 mrt. 15	5365
Function field issue function field	1 mrt. 15	4834
Purchase Order Function Field Issue function field	0 mrt. 15	4495
Why I get this 'str' object is not callable error with my new function field? Opgelost function error field	2 feb. 17	8552
Is there a way to connect to SQL Server Database from an odoo module? Opgelost module sql connect	2 apr. 15	16083

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!