What size is the field? Byte? 2? 4? 8?
B+
HALinNY
=> Subject: Auto Inc as PK index
=>
=> I am using an auto inc field as the pk index tag.
=>
=> Today the user could not add a record due to pk uniqueness violated?
=>
=> I opened the table and found the "Next Value" set to "4"?
=> There are over
=> 275 records already in the table. I opened on older backup
=> of the table and the "Next Value" was okay.
=>
=> Does anyone know how the "Next Value" field could be reset
=> to an apparently random number?
=>
=> James E. Harvey
©2006 Hal Kaplan |
