O$: SQLite, Table.$dowork() and sequence numbers
pmulroney at logicaldevelopments.com.au
Wed Jul 27 00:54:28 UTC 2022
I figured out the $dowork() etc. In our system we have a couple of extra fields in each database table to show the data/time last updated, the last operation performed, and a system-wide id independent of the RowID/RecordID/Sequence number. We added code into $dowork(), $insert(), $update(), $doinsert() to set these fields for us automatically, so the main code doesn't need to worry about it.
> On 27 Jul 2022, at 12:02 am, Das Goravani <goravanis at gmail.com> wrote:
> I don’t use $dowork() or similar in my astrology app.
> I haven’t got anything on how to make dowork and do insert do the right thing.
> I imagine it’s like you are trying, you’d have to override those methods and put in something to grab the lastrowid as you are doing.
A day without sunshine is like, night.
Paul W. Mulroney We Don't Do Simple Pty Ltd
pmulroney at logicaldevelopments.com.au Trading as Logical Developments
www.logicaldevelopments.com.au ACN 161 009 374
Ph: +61 8 9458 3889 86 Coolgardie Street
BENTLEY WA 6102
More information about the omnisdev-en