>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!!!
USE mytable ALIAS tbl1 IN 0 USE mytable2 ALIAS tbl2 IN 0and later reference the tables only by there aliases in the code.