[web2py] Re: autoincremente field with a specific first value

2012-08-14 Thread tigmmi
I would like to have it on DAL mysql specific. I found the _befor_insert and other events very intresent and can hel in many part of my code. Thansk to Massimo. On Monday, August 13, 2012 6:33:59 PM UTC, Cliff Kachinske wrote: > > In MySQL there is > > ALTER TABLE mytable AUTO_INCREMENT = 500 >

[web2py] Re: autoincremente field with a specific first value

2012-08-14 Thread tigmmi
I would like to have it on insert. Like for example a mouvement number that start with 100 not 1 as is the case for id. I have foud another alternative in fiorm.accepts(): def index(): """ example action using the internationalization operator T and flash rendered by views/default/inde

[web2py] Re: autoincremente field with a specific first value

2012-08-13 Thread Cliff Kachinske
In MySQL there is ALTER TABLE mytable AUTO_INCREMENT = 500 Is that what you want to do? On Friday, August 10, 2012 11:46:54 AM UTC-4, tigmmi wrote: > > Is there a way to add an autoincremente field with a specific first value. > Compute won't work with id + number. --

[web2py] Re: autoincremente field with a specific first value

2012-08-12 Thread Massimo Di Pierro
Do you mean something like this? db(query).update(field = db.table.field+value) On Friday, 10 August 2012 10:46:54 UTC-5, tigmmi wrote: > > Is there a way to add an autoincremente field with a specific first value. > Compute won't work with id + number. --