The SQLite FAQ was very helpful regarding creation of an AUTOINCREMENT field.
It said we should declare a column (say colNum) INTEGER PRIMARY KEY, which will then autoincrement. Seems to works fine. I've deleted rows, but each new row added has a number one larger than the greatest ever placed there. Is there a way to determine what number was (or will be) assigned in colNum to a new INSERT, so that number could be used as a cross- reference in another table or database? IOW, I suppose, is there an SQL query to quickly determine max ROWID? If not, the FAQ says the API function named sqlite_last_insert_rowid() which will return the integer key for the most recent insert operation. Does that actually mean the max ROWID on a table which has been opened but not yet used? Or is that number returned only after once accessed? Thanks
