Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Listbox with SQL RowSourceType
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00612945
Message ID:
00612955
Views:
20
Ah ha! Thanks. I just setup the rowsource in the form's init and it work.

Thanks alot!



>>I have a list box using RowSourceType - 3 (SQL). The RowSource is:
>>
>>
>>select ffield, fcondition, fvalue from InvRptFilter where fsessionid = thisform.sessionid into cursor cFilter
>>
>>
>>When the form loads I get an error "thisform can only be used in a method" however, when I add some records into invrptfilter and requery the listbox, I don't get the error and the listbox displays the additional records as I would expect.
>>
>>Is there a better approach to using a filtered listbox?
>>
>>TIA!
>>
>>Rob
>
>
>The listbox is instantiating before the form is known.
Previous
Reply
Map
View

Click here to load this message in the networking platform