Re: [tryton-dev] change party address using cursor

2013-08-21 Thread Demoy Blake
On Wednesday, August 21, 2013 11:47:15 AM UTC-5, Nicolas Évrard wrote: > > * Demoy Blake [2013-08-21 18:11 +0200]: > > >> >thank you for the advice, Hi Évrard how might I alter a specific party > >> >address without resulting to sql statements > >> > >> Due to the switch to the active record

Re: [tryton-dev] change party address using cursor

2013-08-21 Thread Nicolas Évrard
* Demoy Blake [2013-08-21 18:11 +0200]: >thank you for the advice, Hi Évrard how might I alter a specific party >address without resulting to sql statements Due to the switch to the active record pattern it is now quite easy to change the value of field: http://hg.tryton.org/modules/sale_sup

Re: [tryton-dev] change party address using cursor

2013-08-21 Thread Demoy Blake
> >thank you for the advice, Hi Évrard how might I alter a specific party > >address without resulting to sql statements > > Due to the switch to the active record pattern it is now quite easy to > change the value of field: > > > http://hg.tryton.org/modules/sale_supply/file/5c867861be

Re: [tryton-dev] change party address using cursor

2013-08-20 Thread Nicolas Évrard
* Demoy Blake [2013-08-20 18:51 +0200]: * Robert Schöftner [2013-08-20 09:30 +0200]: >Am 2013-08-20 01:43, schrieb Demoy Blake: >> Hello, I am trying to change the address of a party using the database >> cursor, below is the SQL statement but its not working. >> >> cursor.execute('UPDATE party

Re: [tryton-dev] change party address using cursor

2013-08-20 Thread Demoy Blake
On Tuesday, August 20, 2013 3:06:24 AM UTC-5, Nicolas Évrard wrote: > > * Robert Schöftner [2013-08-20 09:30 +0200]: > >Am 2013-08-20 01:43, schrieb Demoy Blake: > >> Hello, I am trying to change the address of a party using the database > >> cursor, below is the SQL statement but its not wor

Re: [tryton-dev] change party address using cursor

2013-08-20 Thread Nicolas Évrard
* Robert Schöftner [2013-08-20 09:30 +0200]: Am 2013-08-20 01:43, schrieb Demoy Blake: Hello, I am trying to change the address of a party using the database cursor, below is the SQL statement but its not working. cursor.execute('UPDATE party_address ' 'SET country = 111, '

Re: [tryton-dev] change party address using cursor

2013-08-20 Thread Robert Schöftner
Am 2013-08-20 01:43, schrieb Demoy Blake: > Hello, I am trying to change the address of a party using the database > cursor, below is the SQL statement but its not working. > > cursor.execute('UPDATE party_address ' > 'SET country = 111, ' > 'street = "pen" ' > '

[tryton-dev] change party address using cursor

2013-08-19 Thread Demoy Blake
Hello, I am trying to change the address of a party using the database cursor, below is the SQL statement but its not working. cursor.execute('UPDATE party_address ' 'SET country = 111, ' 'street = "pen" ' 'WHERE party = 111') #below is the error message i kee