[Solved] Inconsistent record numbering

Creating and using forms

[Solved] Inconsistent record numbering

Postby gkick » Thu Nov 28, 2019 2:19 am

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.
Last edited by gkick on Thu Nov 28, 2019 6:28 pm, edited 1 time in total.
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 221
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Inconsistent record numbering

Postby Villeroy » Thu Nov 28, 2019 12:17 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28153
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Inconsistent record numbering

Postby F3K Total » Thu Nov 28, 2019 6:11 pm

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
    MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
    my current system
  • Windows 10 AOO, LOLinux Mint AOO, LO
F3K Total
Volunteer
 
Posts: 964
Joined: Fri Dec 16, 2011 8:20 pm

Re: Inconsistent record numbering

Postby gkick » Thu Nov 28, 2019 6:27 pm

Thank you guys 8-)
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 221
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile


Return to Forms

Who is online

Users browsing this forum: No registered users and 2 guests