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
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.