Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error Message - Cannot Access Table
Message
 
 
À
11/08/2003 16:00:38
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00819030
Message ID:
00819177
Vues:
15
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform