>hey,
>thanx 4 the help..
>
>i want to insert data frm Mysql to dbf..
>Im doing the following
>
>sqlexec(lccon, "select * from mysqltable where source=1", "crsTest")
>
>-->The mysql table has a field called source but this field isnt there in the vfp table. other fields are same.)
>
>insert into myvfptable;
>(field1,field2);
>values(crstest.field1,crstest.field2)
>
>i KEEP GETTING THE ERROR "COLUMN 'SOURCE' NOT FOUND" why is it looking for the column source in the dbf file???
Can you post the actual code?
If table MySqlTable has colums named [SOURCE] with this select it must be in crsTest cursor.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.