Brandon,
I think you tickled the right neurons. I misread the SQLite web page.
Below is the statement from the web page. The italics is how I
mis-interpreted it.
If no ROWID is specified on the insert, an appropriate ROWID is
created automatically. The usual algorithm is to give the newly
created row a ROWID that is one larger than the largest ROWID in the
table prior to the insert.
/If no ROWID is specified on the insert, an appropriate ROWID is
created automatically. The usual algorithm is to give the newly
created row a ROWID that is one larger than the largest ROWID *ever
inserted in the table*./
Thanks Brandon.
Brandon, Nicholas (UK) wrote:
I have not reach a point of creating a "maximum possible ROWID", I'm
only at three rows. The behavior I was desiring is:
If no ROWID is specified on the insert, an appropriate ROWID is
created automatically. The usual algorithm is to give the newly
created row a ROWID that is one larger than the largest ROWID in
the
table prior to the insert.
Based on your previous example its doing exactly the behaviour
described.
Try
DELETE FROM abc WHERE ROWID='2';
INSERT INTO abc(c,p,t) VALUES('t5', 26, 't8');
SELECT * FROM abc;
I would expect 'masked' to be 1,3,4
********************************************************************
This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender.
You should not copy it or use it for any purpose nor disclose or
distribute its contents to any other person.
********************************************************************
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
