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:
00083545
Views:
22
>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.

Eric, you can open your cursor in the LOAD method (or elsewhere), calling it with RowSourceType Alias, RowSource MyCursor. This is Ed's approach.

Or, you can set the RowSourceType to SQL and put the code for your SQL statement into the RowSource. Include the INTO CURSOR.... statement, and the list will be loaded automatically when the listbox is initiated. From that point on the cursor is available just like any other cursor.

HTH
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform