Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Database object is being used by someone else
Message
From
08/01/1999 16:41:59
 
 
To
08/01/1999 16:14:51
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00172901
Message ID:
00174215
Views:
26
>Hi Erik.
>
>>What causes this error?
>
>I haven't run into this but Bruce Allen has. If I recall, it's due to VFP locking the DBC record for a view for a short period of time (I think it's while the view is being opened). If someone else tries to open the view at the same time, VFP doesn't like the view record being locked and gives this error.

Hi Doug-
This is what I have put together as well.
Unfortunately, I am getting this error quite often at one of my sites (once or twice a week maybe). I am trying to work towards an elegant error handling solution to this. I have looked through your error handling framework and didn't find anything specifically to deal with it (I could have missed something?).

What I have tried to do is trap for the error and allow the user to cancel or retry. Since I think the record is only being locked for a split second, I thought this strategy would work nicely. Unfortunately though, issuing a RETRY from the error routine produces a VFP error (not trappable) that says something like "Mismatched Pushjmp/Popjmp call" and the app quickly exits. Not as elegant as I would have hoped. Do you have any insights?
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform