Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL ListBox
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00083297
Message ID:
00083797
Views:
20
>>>Sawadee,
>>>
>>> If the RowSourceType is set to SQL Select and RowSource is an SQL Select statement with the INTO CURSOR clause added, what then?
>>>There doesn't seem to be any further explanation for getting the values into the list from the cursor.
>>>
>>>Eric K.
>>
>>Use List.Rowsourcetype=2 (alias), and List.Rowsource="curList" - cursor name.
>
>If I use 2-Alias, how can I use 3-SQL Statement for the same list?
>
>Eric

I set the List.Rowsourcetype=3 and
List.Rowsource = "Select this,that from MyTable where this = .t. into cursor cWork"

and this works just fine. I have found the documentation for the effective way to use the rowsourcetype options fairly thin on the ground and have huge sympathy for anyone trying to work with them.

I guess if you want to use the cursor you'd need to generate it in your init statement.

Sarah
Sarah King
pcpropertymanager.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform