Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL views - Record locking
Hi,
Problem Scenario - I have a SQL database which can be accessed by a user as well as by a FoxPro program. I pull the SQL record down to foxpro(create SQL view command used), perform certain calculations, issue an SQLEXEC('update statement'). In the meantime the a user accesses the same SQL record and tries to update it. Problem Scenario explaination with an example -
SQL table - MyCounter, Field - NextCounter
Foxpro program runs - pulls down the following details : NextCounter=100
Foxpro program performing calculations
Before the foxpro program issues the update statement, a user access the
same table and same record => NextCounter=100; updates NextCounter=101
The user should not be able to update the record if the foxpro program
has pulled down the record for processing.
Question - How can I implement record record locking of the SQL record?
Neetu Kumar
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