Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot access selected table
Message
De
12/09/1999 14:42:16
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00263733
Message ID:
00263816
Vues:
34
>My class-based form has pages with a list-box on each one. I populate those listboxes with the results of a SELECT. This displays just fine initially. Also, I populate a listbox outside of the pageframe with the results of a SELECT, a dataset from several tables, including the one just created for the afore-mentioned listbox. (I'm sorry, I write fiction, hence the verbosity). The error message appears, and the listbox disappears from the page... neither table created by the SELECTs is not at EOF(). Why do I get a 'Cannot access selected table' and see the listbox disappear? Properties for the shy and prematurely retiring listbox are:
>BoundColumn=2 (text field)
>ColumnCount=2
>DisplayValue=(None)
>RowSource=ABC.PatName,PIDCode
>RowSourceType=6 - Fields
>TablIndex=1
>The rest are height and width and location goodies. The InterActiveChange event has the following:
>LOCAL cCurrCode
>
>SELECT Patient_
>LOCATE FOR PIDCode = ABC.PIDCode
>cCurrCode = PIDCode
>SELECT ABC
>
>WITH THISFORM
> .MakeLists("ABC",cCurrCode)
> .pgf.page1.TxtPIDCode.REFRESH()
> .pgf.page1.TxtSex.REFRESH()
> .LstProcs.REQUERY()
>ENDWITH
>
>Anyone?
>TIA, Robin

It's common trap. You should unlink listbox (or combo) from its rowsource right before you fire select to re-populate it.
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform