Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating a rownumber?
Message
From
19/09/2013 09:56:28
 
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 6.5 and older
Application:
Web
Miscellaneous
Thread ID:
01583615
Message ID:
01583626
Views:
36
>Ah, ok.
>
>If you can implement an identity column in the SQL database, it will help in many ways.
>
>I don't believe RecNo() isn't 100% reliable, since it's possible someone could delete a row and then pack, in between the time of data retrieval and then a save. Not a likely scenario, but an identity column is going to be better.

And I can call my identity column recno.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform