Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot access selected table
Message
 
To
21/08/2001 11:43:35
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00546743
Message ID:
00546849
Views:
19
>>I have gotten this message before "CANNOT ACCESS SELECTED TABLE" and unfortunately, it doesn't generate an error so it's hard to debug. But I now get it during the interactive change of listbox1:
>>If thisform.mylistbox1.selected(1)=.t.
>>select * from office2 into cursor whichoff
>>endi
>>If thisform.mylistbox1.selected(2)=.t.
>>select * from office1 into cursor whichoff
>>endi
>>If thisform.mylistbox1.selected(3)=.t.
>>select * from office0 into cursor whichoff
>>endi
>>If thisform.mylistbox1.selected(4)=.t.
>>select * from office9 into cursor whichoff
>>endi
>>
>>thisform.mylistbox4.rowsource='whichoff'
>
>Tim,
>Change your myListbox.Rowsourcetype to SQL and define SQL in its rowsource.
>
>
*myListbox4.init
>with this
> .Rowsourcetype = 4
> .Rowsource = 'select * from '+;
> '(crsOffices.Office) into cursor whichoff'
>endwith
>
>*myListbox1.init
>with this
> .Rowsourcetype = 4
> .Rowsource = 'select ...,OfficeCursorName as Office from '+;
> '... into cursor crsOffices'
>endwith
>*Valid
>with thisform.myListbox4
> .requery
> .listndex=0
>endwith
Cetin, I would like to try this but is this line gramatically correct?
{.Rowsource = 'select ...,OfficeCursorName as Office from '+;
> '... into cursor crsOffices'}
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform