>>I am completely stumped by this error (error 1815). The error is listed in the help as...
>>
>>*****
>>"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.
>>*****

>You should SELECT ... INTO CURSOR ... NOFILTER
>BTW, it may generate error in VFP5 too

Thanks Ed, it worked.

I am still making the transition from VFP3 where I didn't need the NOFILTER clause. What I find weird is that I use successive queries throughout my application and they all are working (except the example given) in VFP6. Very strange... In the morning I will put NOFILTER in all those queries.

Thanks for your help.