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? > > Are there alternatives? > > Thanks! > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
