Tom
Make sure to reload the database and watch for any errors. It sounds like
the table (PK) is corrupt. Make sure the code isn't trying to insert a value
into the PK field.
Check to see what the max number is for the column then at the R:Prompt
AUTONUM colname IN tblname DELETE
AUTONUM colname IN tblename USI yourNewStartNumber, 1 NONUM
Buddy
From: [email protected] [mailto:[email protected]] On Behalf Of Tom
Frederick
Sent: Monday, June 24, 2013 1:39 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Primary Key Autonummber changes
I have run into a string of Primary Key auto-numbers that change for no
reason I can see. Table 'Goals' is associated with Table 'Objectives'.
Objectives has 1020 rows and the most recent row is 1020. This morning,
users are getting errors when they add new rows to Objectives. When I use
Design Table to look at the PK auto-number value it says 954. Obviously, if
a new row gets added an error is thrown. This is not the first time this has
happened. What could cause a PK value to change? I rebuild the database
regularly. Is there any way I can reset the PK value to 1021 (or whatever I
need) while users are still active in a compiled v95 database with latest
updates.
Tom Frederick
President/CEO
Elm City Center
1314 W Walnut
Jacksonville, IL 62650
W- 217-245-9504
F - 217-245-2350
E - [email protected]
