>>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.