Hi, Does last_insert_rowid() return the identity of the main insert or would it return the id of a row inserted by a trigger if the main insert caused a 2nd insert to occur on another table via a trigger?
SQL Server has a scope_identity() function to make sure you can get the original id regardless of any tigger that might have fired. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_6n8p.asp What does SQLite have to ensure a trigger does not mess up the retrieval of the last row id? Thanks, Mike -- View this message in context: http://www.nabble.com/last_insert_rowid%28%29-t1690790.html#a4588358 Sent from the SQLite forum at Nabble.com.
