Page 1 of 1

[Solved] Inconsistent record numbering

PostPosted: Thu Nov 28, 2019 2:19 am
by gkick
Just an observation.
while testing updating a record with the current user name after changing a record I noticed that when I update record number 2 in the entry form I am actually changing record number 1 in the underlying table since table records start with 0.

Re: Inconsistent record numbering

PostPosted: Thu Nov 28, 2019 12:17 pm
by Villeroy
You can start the ID numbers with any integer number and increment with any integer other than 0. The auto-value is not a concrete row number. It is a unique index number distinguishing one record from another. It would still work if it were generated as a random integer.

Re: Inconsistent record numbering

PostPosted: Thu Nov 28, 2019 6:11 pm
by F3K Total
if you want, in an allready filled table, to raise the ID by 1 you can use via Tools/SQL...
Code: Select all   Expand viewCollapse view
UPDATE "Table1" SET ID = ID + 1
now Menue View/Refresh Tables

Re: Inconsistent record numbering

PostPosted: Thu Nov 28, 2019 6:27 pm
by gkick
Thank you guys 8-)