General information
Category:
The Mere Mortals .NET Framework
>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.
I dunno, but why would you want to show a PK in a textbox?
Here's hoping all is well in Maine. It's looking highly unlikely that I will make it out there this summer.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only