Paul's SQLite Question
goravanis at gmail.com
Tue Jul 26 15:58:30 UTC 2022
I use SQLite on my astrology app. And I use table classes to do it all.
To get the unique key field back I just use $lastrowid()
You put in that column as #NULL and SQLite then assigns nextval to it.
$lastrowid returns it.
SQLite expects to be single user, so there is no chance of other users records getting in there in-between to mess up which is the last row ID.
Even in multi user the chance that a record gets inserted in the intervening time is really slim.
So $lastrowid is safe.
That’s all I got on that matter.
Do tvSessObjRef.$lastrowid() Returns irowid
Calculate $cinst.[tvrsnfieldname] as irowid
More information about the omnisdev-en