>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

You should add a NOFILTER clause to your selecte statement so the real cursor on the disk with be created. Otherwise it just filters myTable3. Also don't use numbers for workareas, always use in 0 instead, so VFP will open table in the new free area.