yes, what you have is a filtered result set, which is the CURSE of VFP!

Add the NOFILTER clause and all should be well.


>The instruction ...
>

select * from sometable into cursor c_effe

>creates the cursor c_effe even if that cursor already existed. In that case the old cursor is replaced by the new one. That's normal behavior, right?
>
>However, now I have an example where the error 'Alias name is already in use' is displayed. Amd eventually an error c5 will be the second consequence.
>
>Anybody here familiar with this behavior?