Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with tableupdate?
Message
From
15/06/2000 14:11:30
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00380439
Message ID:
00380885
Views:
13
>What is SET REPROCESS set to. It sounds like it is set to AUTOMATIC and you are running into a locking issue.
>
>>>My clients are experiencing what appears to be a freeze that I have narrowed down to a tableupdate(.T., .F.) call. When I run the code on my standalone PC all is fine. In their environment (running app & database off a novell server) the call to tableupdate gives the impression that it is "hung". If the user presses esc control returns to the app and everything appears to be fine including all updates. Pressing esc has no effect other than in this situation though.
>>>
>>>Any insight would be much appreciated.
>>>
>>>Thanks much
>>>Todd Collins
>>>Todd_Collins@sobeys.net
>>
>>To clarify all pressing does is terminate the tableupdate command and return processing to the next line of code. The tableupdate returns success.
>>
>>Thanks again.
>>Todd

Thanks Matt. This definitely sounds like it explains what is happening. In my case reprocess was set to 0, not automatic but the esc behaves the same. Now I just have to figure out why there might be lock issues. In this case no other users are in the system.

Cheers
Todd
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform