Mark,

I tried this, but I didn't get any errors. I can do several times
select * from cursor1 where somecondition into cursor cursor1
use (dbf("cursor1")) again in 0 alias cursor2
etc. creating cursor3, cursor4.
So, my conclusion is, it is possible. There must be some side condition (is dat engels voor randvoorwaarde?) that is causing problems. You haven't exactly indicated what the problem is, also.

I noticed in my own code where I thought I was using a similar construction that I had changed this into:
select * from cursor1 union select ... into cursor2
select * from cursor2 into cursor1
(executed several times in a loop)
I just cannot remember what kind of problems I had that me change this code. I think it was some incidental error message I could not explain and decided to work around.


Can you explain a little more about your problem? Maybe you should use the nofilter claus in your select?



Auke