Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot access selected table
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00263733
Message ID:
00263882
Vues:
22
>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

Robin,

I suppose you get the error when you want to close the form. This was not clear in your message.

If this is the case, check for some GotFocus() or Refresh() code that fires for your listbox when it has already lost its control source. This type of error is not easy to trap.

José
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform