Paul's SQLite Question

Das Goravani goravanis at
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 mailing list