Very weird. As long as the work around works:)

>Jayesh,
>Thank you very much for your help.
>
>I tried SQLROLLBACK() and SQLCOMMIT(), rather put it in a DO LOOP for 20 times with error logging off but still did it.
>
>So I did a drastic thing. After every SAVE of the record, I CLOSE DATABASES ALL and then THISFORM.DATAENVIRONMENT.OPENTABLES( ). This has fixed the problem.
>
>Opening the tables again does not involve any overhead as all views in the DE are parameterized views, so no data comes across.
>
>Abdul Ahad
>
>
>>Your are right. This has to do with open transactions. Is the framework using manual transactioning?
>>
>>I had to fix this in CodeBook frameworks by calling SQLROLLBACK() in the UnLoad() of the base form. Also you need either issue SQLCOMMIT() or SQLROLLBACK() after a call to SQLEXEC() if the data is being updated.
>>
>>>Hi All,
>>>I am using VFP6 and Visual Promatrix Enterprise 6.
>>>
>>>I have developed a number of applications with SQL Server 2000 at the
>>>backend.
>>>
>>>One of my applicataion has 75 users who log on simultaneously. I have
>>>started experiencing a problem with SQL Server. Randomly, one user BLOCKS a
>>>table.
>>>
>>>If u go into SQL Server Enterprise Manager and into MANAGEMENT/CURRENT
>>>ACTIVITY/LOCKS, one user is BLOCKING a lot of other users.
>>>
>>>The BLOCKING user may not have any form open. He had entered some data and
>>>then closed the form. Now, the BLOCKING does not release till he exits the
>>>application.
>>>
>>>This phenomenon occurs when he hits the SAVE button on the toolbar. After
>>>that this BLOCKING occurs. It is random. May not happen the whole day and
>>>may happen three to four times a day. But then the table that is LOCKED, is
>>>not available to anybody else and their system hangs.
>>>
>>>Anybody else also faced this problem? I think this happens when VPM does not
>>>release a TRANSACTION. I may be wrong.
>>>
>>>I have been working with VFP6 and SQL Server 6,7,2000. but did not face this problem there. It only happens in VPM.
>>>
>>>Would appriciate a quick reply as some of the users are now fed up of
>>>CTRL+ALT+DELing out of their application.
>>>
>>>TIA
>>>
>>>Abdul Ahad
>>>CSi
>>>www.csi-pk.com