Hi!

What is the VFP version?

Try to use
SELECT * FROM mytable3 WHERE f1 = "A" INTO CURSOR csrTemp nofilter

or

USE mytable3 in 0
SELECT * FROM mytable3 WHERE f1 = "A" INTO CURSOR csrTemp

And see if it change something.



>hi,
> I have problem that, SELECT-SQL ...INTO CURSOR statement may "overlap" my opened workarea.
>
>

>USE mytable ALIAS tbl1 IN 1
>USE mytable2 ALIAS tbl2 IN 2
>
>**the code above work fine
>SELECT * FROM mytable3 WHERE f1 = "A" INTO CURSOR csrTemp
>
>

>VFP doesn't create the cursor on workarea 3, instead it may overlap the previous workarea..work area 1 or 2.. so.. i try to not open any tables on that workarea which VFP will always create the cursor in. It work fine at my office. However, the error occured again if i move my project to other computer!!!
>
>How to solve this?
>
>Thank you