Perhaps I am making something difficult when I shouldn’t. I have a SQLite database table with a column as “pkRecID INTEGER PRIMARY KEY”. I have a situation where I add a new record to the table that is really just a skeleton with a couple of primary columns entered. Right after I add the new record I need retrieve it but I don’t yet know what the new pkRecID is (that’s actually why I am retrieving it).
Is there a way to just recall the last record added, or retrieve MAX(pkRecID) or something?