I am curious as to why you used the NOFILTER parameter? The VFP docs below indicate there is a performance hit and the temporayr table is not updateable per my test. You can close a cursor created with "SELECT * FROM myfile INTO CURSOR myquery" with "use in myquery".
If I am wrong, please advise.
Robert Baker
From VFP 6 help:
"Include NOFILTER to create a cursor that can be used in subsequent queries.....
Including NOFILTER can reduce query performance because a temporary table is created on disk. The temporary table is deleted from disk when the cursor is closed."
>>Here goes:
>>
>>When I use a SQL instruction as my RowSourceType (option #3) in a listbox and then set the RowSource property to a valid SQL query ('SELECT * FROM sales' for example), a browse window always pops when I run the form containing my listbox. Why is that and how can I change it?
>>
>>Thanks, Steph.
>
>Set it to "SELECT * FROM sales INTO CURSOR cuComboCursor NOFILTER"
Robert - Zxytek