From: "P Kishor" <[EMAIL PROTECTED]> >> I would know if there a some way to know the last insert in a know >> table. >> >> Some like the result returned by sqlite3_last_insert_rowid(), but >> referred >> to a specific table inside the database connection, and not in all >> tables >> into the database from the database connection. > > last_insert_rowid() is indeed the result of the insert into a > *specific* table, the one that happens to have a row inserted at the > very last! You can't possibly insert the "last" row in *all* the > tables just like you can't take away the last coach from a train... no > matter what you take away, there will always be a last one. > > When the *next* insert operation happens, the result of that insert > will become the last insert.
Puneet: Thanks for your reply, but let me be a bit more concise. I need update several tables in a dBase, and after all, I need to know the las insert id of one, or several of them. Odviously I can keep a variable with the last_insert_rowid() of each specific table, obtained inmediately after the update of the table/s of my interest, but I try avoid global variables, so my question. Thanks anyway. A.J.Millan _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
