Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>How are you generating the numbers?
>
>>>Have you checked for DELETED() records?
>>>
>>
>>Yes, I should have mentioned in my initial post - both rows are active (not deleted) That is, the row that is supposed to have ID 7 (but was changed to 13) is not deleted. Nor is the row that is supposed to have ID 13 (and still has 13).
I should also mention that, according to the audit trail, neither record was ever deleted.
I use a Primary Key table that has the last Id value used for each table. The default value of the key fields calls a stored procedure, SP_IDNEXT, which looks up the tablename in my Primary Key table, locks the appropriate row, increments the value, Unlocks the row and then returns the new id.
Also, the tables (and method of assigning IDs) has been in place for years - since VFP3. This has become an issue only in the past several months. I'd guess there are around 150 entries in the Primary Key table (ie. around 150 tables. This is the only table that has this problem.)
Thanks,
Alan
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement