General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Sorry for taking so long to get back to you. I just now discovered the replies button on the top of the web page.
I avoid autoincrements mainly because of the gymnastics that I have to do find out the PK when a record is added in VFP. I think it is better to get the PK from a control table and then insert a record into a view or cursor and then insert the row into the table when the user says the data is correct. I was burned badly one time when I was using @@identity to get the PK and what I was getting was a tables PK that was being inserted by the trigger.
I was also told that autoincrements should be used in a replicating system. I must admit that I have not used a version of SQL Server greater than 6.5. I have mainly use Sybase SQL Anywhere for the last 4 years.
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