Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot access selected table
Message
From
18/10/1998 19:02:34
Cheryl Qualset
Qualset Computer Consulting
Davis, California, United States
 
 
To
14/10/1998 17:16:52
Bob Lucas
The WordWare Agency
Alberta, Canada
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00145783
Message ID:
00147974
Views:
27
>>>Try setting the form data session to "private"
>>>HTH
>>>//:^)
>>
>>Thanks for the reply.
>>
>>However, Private is the MM default and I haven't changed it.
>>
>>Cheryl
>>
>>>>I have a form with a primary and child biz obj.
>>>>
>>>>The child can 0 or 1 records per parent record, depending on the setting of a (radio button) field in the parent.
>>>>
>>>>Sometimes, since I have implemented this in a cNoListBizObjMaintForm, when the form is closed, I get one or two 'cannot access selected table' error messages. These are VFP error messages, not app error messages.
>>>>
>>>>Anyone have this experience?
>>>>It seems to come from the cleanup/dataenvironment area, but I have left this problem alone for a while.
>>>>
>>>>Cheryl
>
>
>You may be closing a table manually (with a USE statement) when the destroy of the data environment object is trying to do it. Or a table may have been inadvertently closed for another reason and when the data environment destroys it looks for all the tables it opened and essentially does a SELECT and USE. If the table isn't open, you get the error.

I have stepped through the whole thing and never USE anything in my custom code.

I can open my app, open this form, close it without touching anything, and get the error. Or, I can open the app, open the form, close the form, no error. It is sporatic. I can open the app, open and close the form 10 times and get the error twice. I can't give it to my users like this. I am stuck.

Cheryl
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform