Did you do the insert in the shell also? If so, when you do inserts, updates, deletes in the shell, you have to follow with db.commit() in order to commit the transaction. This is not necessary in application code because the framework does that automatically at the end of a request. I have also found that in some cases, the web-based shell in admin does not work for database transactions, so you may need to use a regular OS shell.
Anthony On Thursday, March 15, 2012 4:12:10 AM UTC-4, Stefan Scholl wrote: > > web2py 1.99.7 for Windows. > > Example app, inserted 1 person and 1 dog. > > In the shell: > > dogs = db().select(db.dog.ALL) > > > Nothing there. And "dogs" isn't defined. > >