[web2py] Re: Legacy Tables: Can't Insert rows. Nothing back from db._lastsql

2011-08-01 Thread Andrew
Thanks Anthony, It's mostly working ! I ran web2py from the shell (for the first time) and I was able to successfully add a row. I did forget to do a commit. Thanks for the tip. print db._lastsql also works. Sounds like I shouldn't bother with the shell in the admin screen. The appadmi

[web2py] Re: Legacy Tables: Can't Insert rows. Nothing back from db._lastsql

2011-08-01 Thread Anthony
First, if you're in the shell, you need to do db.commit() for your DB transactions to be committed (see http://web2py.com/book/default/chapter/06#commit-and-rollback). Also, if you're using the web-based shell via the 'admin' app, sometimes it doesn't work so well -- you might be better off usi