Hi Frank, thanks for the reply.
>when using a VFP back end I use a similar process to generate keys, but >for SQL Server I use an identity column for my PKs. FWIW any new >developement in VFP I'll look at using an autoinc field.
I'm not sure my client would be happy with the values allocated by SQL - they want to have more control over number ranges. If it was VFP alone I wouldn't have the update problem, because I could use RLOCK() to ensure that only one user could update the value at any one time. Theoretically, using the key and modified fields in the UPDATE command should work, but I guess there's something I'm missing in my code.
Regards,
Alan
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