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