yeah , the mysqltable has a column named source.. Im trying to select data frm the Mysqltable based on the source field and then insert it into a vfp table that is similar to Mysqltable except that it doesnt have the source field.

the code i posted is the actual code. i guess in the sqlexec function I shouldn't do a "select * from mysqltable". this is wat i was trying to do:

sqlexec(lccon,"select * from mysqltable where source=1","crstest")

then i tried to insert the selected value into the dbf file

insert into dbftable(field1,field2) values (crstest.field1,crstest.field2)