Dixon Hutchinson wrote:
I have not reach a point of creating a "maximum possible ROWID", I'm only at three rows.
it's a matter of definition... if you just reached three rows, without deletions, then the maximum rowid is 3.
If I actually specify AUTOINCREMENT, then an insert will fail when I have reached the max row value, even if there are unused rows in the table.
true. in a computer you have a limited amount of numbers. sooner or later you use them up. if you don't specify AUTOINCREMENT, then an insert will fail when the table is full (not a hole to be found!). if you do specify AUTOINCREMENT, then an insert will fail when there isn't any historically unique rowid available.
So I don't want to specify AUTOINCREMENT.
which, translated into English, reads: "so I want to reuse rowids". are you even more confused than before? hope not. Mario. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
