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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement