Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot access selected table error, rowsourcetype=6
Message
De
07/09/2005 14:16:29
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Cannot access selected table error, rowsourcetype=6
Divers
Thread ID:
01047438
Message ID:
01047438
Vues:
47
I get 'cannot access selected table' error in my .REFRESH() as rowsourcetype is assigned to 6. The error only occurs 1st time the code is executed (at this time, the combolist dissapear from the screen). Subsequent run does not give error (combolist reappear, properly populated). Oh, actually, when the form is loaded the very 1st time (at which time .REFRESH() is also executed), I get no error & combolist displayed correctly. When I then clicked on my update button which calls the .REFRESH(), I get the error & combolist dissapear. If I clicked on in again, then combolist reappear & no error message.

In THISFORM.Refresh():
*********************
SELECT ALLTRIM(last)+', '+first as xAuthoFor,cAutho.authofor ;
FROM cAutho LEFT JOIN cEmp ON cAutho.authofor=cEmp.empid ;
WHERE UPPER(cAutho.empid)=UPPER(cERCA.enterBy) INTO CURSOR xCAutho

*xCAutho is OK at this point (I can browse it).

THISFORM.PageFrame.Page4.lSubmitFor.RowSourceType= 6
*This is when I can the 'cannot access selected table' error.

THISFORM.PageFrame.Page4.lSubmitFor.RowSource='xCAutho.xauthofor,authofor'
*********************

Any help would be greatly appreciated.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform