Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot access the selected table (Error 1152)
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00045744
Message ID:
00046034
Views:
32
>>>Hi, I have a multi-page frame form calling another multi-page form and this error occurs between "thisform.Release()" and the instruction after the "DO FORM". If I click on "OK", the form carries on working perfectly. Can anyone tell me how to find which table the error applies to. The description of the error states: "You have attempted to select a table outside the 32K work area range or are attempting to reference a file variable in a table that is not open."
>>>
>>>Thanks in advance
>>>Petras
>>
>>Petras, check the alias names of each of your tables before you close the first form. (Use the debugger) Also, check your SELECT areas. You may have a typo resulting in a SELECT X or similar impossibility.
>>
>>HTH
>>Barbara
>
>Hi, thanks for your reply. I've checked all the aliases and SELECTs but cannot find any typos. Some additional information: I am using free tables and do not close any before calling the second form. The error only occurs if I go to a specific page on the second form. What I really need is to find the name of the table which VFP is gagging on. I've tried putting code in the Error events of the DataEnvironment of both forms without success.
>
>Rgds
>Petras

Petras, if you've got the error linked to a certain page, then it's either in the DEACTIVATE method of the page you are leaving or somewhere in the activate/refresh code of the page you are loading. Go over every bit of code, including anything in a parent class.

HTH
Barbara
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform