O$: SQLite, Table.$dowork() and sequence numbers

[Paul Mulroney]

Hi Das,

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.

Regards,
Paul.


> 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.
bit.ly/17HOqAI
-- 
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