Hi!
I hope VFP8 auto-increment will be better. I also know that SQL Server 2000 now have better approach for auto-increment identity values too.
>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.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.