This works too: "select IDENTITY_VAL_LOCAL() from %s"%self._tablename
and is more generic, but I only have db2/400 to test. Speaking of db2/400, the automatic journaling problem is still sadly alive, which means that after the tables are created you have to manually start journaling on them before any inserts can be done. Testing the modified sql.py with appadmin I get "Invalid Query" on appadmin/select/db?query=db.person.id>0 but db(db.person.id>0).select() works just fine. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
