When adding a row to a table the ROWID may or may not be the highest value of the table. This can be found with MAX(ROWID) if it is the last. Two problems: what if not last, what if more than one thread. Is there a function that will return the most recent unique value created on the database connection similar to DB2 or NS SQL Server? Thanks _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
- [sqlite] retrieve last unique value written David McDivitt
- Re: [sqlite] retrieve last unique value written Igor Tandetnik
