I have found my problem - it was some stupid configuration problem. But I will still want to leave the question open - What is the best way to create a new 'clean' copy of the database file, resetting all the auto-increment fields?
Thanks, Omri On Tue, Mar 29, 2011 at 11:36, Omri <[email protected]> wrote: > Hello all, > > I have recently come across a strange problem: > > I copied my application to a different name, because I wanted to > create a branch for beta testing of my application. I emptied the > database from all my tests (using Sqliteman - btw - is there a better > way to clear the database and reset the auto incrementing fields?). > > Now when I opened my development (trunk) version, I discovered that it > uses the same (clean) database as the branch. I checked that it really > is the same database by using one application to add data, and view > the data with the second app. This does not happen with the web2py > database administrator, only when I access the data through my > application. > > For both applications I use the default db = DAL('sqlite:// > storage.sqlite'). I am accessing the server through JSONRPC (using > qooxdoo). > > Any suggestions? > > Thanks, > Omri
