>>>Maybe I'm missing somthing :-
>>>
>>>As a test I do :
>>>
>>>Select * from table into cursor cursor1
>>>
>>>and then...
>>>
>>>Select * from cursor1 into cursor cursor2
>>>
>>>On my PC it works fine but on my laptop is says 'Cursor2' must be created with select into table.
>>>
>>>I have tried copying the foxuser onto my laptop from my pc but this does not work. Waht is the setting that causes this?.
>>>
>>>Please help,
>>>Rob
>>
>>I tried your code on my machine and get the same error. The help file indicates:
>>
>>"cursor" must be created with SELECT ... INTO TABLE (Error 1815)
>>You have tried to use a repackaged cursor as a source for another SELECT statement.
>>
>>Some cursors cannot be used in successive queries.
>>Use the INTO TABLE clause of the SELECT - SQL statement instead.
>>
>>***
>>
>>Interesting error, it would be nice to know the definition of 'Some cursors', I wonder what are the ones that can have successive queries.
>
>Brett, what you've got is a "filtered view" of the original table. You should add NOFILTER to the SELECT command to get a real cursor.
>
>To determine if the cursor from a SELECT is a filtered view or not, you can use the DBF() command on the alias andd see if it ends in .TMP or not. If it ends in .DBF, it's a filtered view of the original table and can't be used in additional SELECTs.

Hi, just jumping in on this.

Problem now is speed. Using the NOFILTER or the INTO TABLE means that the query now takes 90 seconds, instead of 90 milliseconds. I'm trying to retrieve about 400,000 records from a table with 1 million records in it. Surely this should be achievable in a very short time?

Has anyone got any ideas?

René.