Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL record locking and transactions
How do I instruct SQL server to lock a specific record, return the data to VFP, and then cater for transaction management?
Clearly, the data will be returned from SQL in the form of a temporary cursor/table, and therefore I have to explictly return the new values to SQL in the form of a stored procedure. This will be a major irritation as some of these tables have 300-400 fields in them.
Also, does this means that record locking would have to be a manual process, i.e. I'd have to use a flag in the SQL database to say "record locked", and reset the flag when the changes have been written back?
Regards
Derek
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