>>>>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
I wound up using RowSourceType-Alias and create the cursor in Load Event as Ed and Barbara suggested. It seems like a cleaner way to do it and I may want to add code to Load later on.

Eric K.