Hi there
The table in question now has around 25000 records (simple -only 3
columns)
Records are added with a simple insert statement :
INSERT INTO SS_REQUEST_SERVICES ( REQUEST_ID, SERVICE_ID ) values(?,?)
and the autonumber field is incrementet with one. No problem ; - all
running smoothly. Today we had a little problem - and looking into it
it seems that over the last year or so there are about 4 instances
where the gap between 2 IDs are more than 1.
Since the autonumber generated is references in another table, I can
conclude that the number was created as it exists in the other table -
but it has disappeared in the table SS_REQUEST_SERVICES where it was
originally "autogenerated" .
This is one is tough - Has anybody else experienced this - is it a
timing issue, a collision issue, compact repair or ???
cheers
larry