[web2py] Re: db.table.insert() inserts a field with id=None but returns an id number

2012-05-09 Thread Omri Har-Shemesh
Additional information: after going through my revision history, it seems that the problem started after I changed the type of a field from string (didn't notice I forgot to define it as integer and therefore it defaulted to string, even though the default=0 was specified). Then, since sqlite

[web2py] Re: db.table.insert() inserts a field with id=None but returns an id number

2012-05-09 Thread Omri Har-Shemesh
Sorry for the frequent e-mails. I just solved the problem - I forgot to set the type of the ID field to INTEGER PRIMARY KEY AUTOINCREMENT, since Sqliteman does not show it as an option. Best, Omri On Wednesday, May 9, 2012 12:15:31 PM UTC+2, Omri Har-Shemesh wrote: Additional information: