Dan Kennedy wrote: > > On Sat, 2007-03-03 at 19:18 -0500, Mitchell Vincent wrote: > > I found the nifty ODBC driver for SQLite and have been trying to use > > it to replace a 2.8 SQlite implementation in some desktop software. > > It's working very well except for a rather large problem of not being > > able to call the last_id API functions. I need to get the primary keys > > assigned to parent tables in order to preserve referential integrity. > > > > SELECT MAX(id) FROM TABLE is one option but it's pretty dangerous > > seeing as multipl people *could* be accessing this database file at > > the same time.. > > What if you wrap the INSERT and "SELECT MAX(id)" statements together > in a transaction?
Or what about issuing a "SELECT last_insert_rowid()" ? Regards, Christian ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------