Hi Neetu see HOLDLOCK in SQL Book on line.
>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
Alexandre Palma
Senior Application Architect