Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error Message - Cannot Access Table
Message
 
 
To
11/08/2003 16:00:38
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00819030
Message ID:
00819177
Views:
14
>Hello Nadya:
>>
>>I glanced through the code, but I don't see, where do you assign anything to combobox recordsource.
>
>RowSource is:
>
SELECT ALLTRIM(UPPER(Last_Name))+", "+ALLTRIM(UPPER(first_name)) as FullName, Health_Num FROM patient INTO CURSOR PatientDemo NOFILTER ORDER BY patient.last_name
>
>RowSourceType = 3

Ok, the little problem with this select - you should padr the result to some number, e.g.
SELECT padr(ALLTRIM(UPPER(Last_Name))+", "+ALLTRIM(UPPER(first_name)),40) as FullName,...

But it's unrelevant observation.
>

Can you check, if PatientDemo is used?

>>Also, may be the problem is that these cursors are somehow closed. Do you know, where do you close these cursors?
>
>I CLOSE TABLES in the Destroy event only, while other action buttons like Save, Delete and Edit simply rebuild the respective cursors to reflect teh change.
>
>Total confusion huh:) (for me it definitely is)

I would comment out CLOSE TABLES in Destroy (you don't need it if you have AutoClose set to .t.) and see, if it makes the difference. In any case, it sounds like these cursors are already somehow closed, which should not be. Can you find out, what method closes them?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform