>Hi Nabil,
>
>I was using BEGIN TRANSACTION/COMMIT TRANSACTION in SQL Server in the SP that inserted the new records for my customers. I do not know whether it is this, or my Remote View that is causing the problem, but now, when I put a SQLCOMMIT() in the save routine before I close the view, everything works fine.
>
>You wouldn't believe how much trouble this problem was causing me! Thank you very much for solving it for me, now I can get back to some real development <bg>.
>
>>>I have had a problem with VFP locking under certain circumstances when I requery a remote
>>
>>Are you using SQL BEGIN TRANSACTION?
>>
>>if yes then you have to set the transaction property of the connection to 2
>>by using SQLSETPROP command, then issue the BEGIN TRANSACTION command,
>>then after commiting/rollback set it back to 1.
Always make sure that whenever you use SQL BEGIN TRANSACTION set the transaction property of the connection to 2(Manual Transaction), if you don't it will lock the application's logged in users.