On 3/18/08, A.J.Millan <[EMAIL PROTECTED]> wrote: > Hi all: > > 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. > > Thanks in advance > > A.J.Millan > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
