Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot access selected table
Message
From
12/09/1999 14:42:16
 
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00263733
Message ID:
00263816
Views:
33
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform