Information générale
Catégorie:
The Mere Mortals .NET Framework
Titre:
Identity in SQL table is incorrect?
Versions des environnements
I have a Sql table (Pur_head) with the primary key (ReqId) set as the identity. The last record in the table shows the ReqId as 58873, so the next record might be 58874, I would expect.
The Pur_head.vb shows this as the primary key as well.
When the code creates a new record, the textbox that shows the ReqID shows 58874. This might have been correct.
Instead the actual last record, using SQL Server Enterprise, shows the ReqId as 58954. It's this number because there were a lot of records deleted from the Sql table.
So why isn't the textbox showing 58954?
Thanks.
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