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