General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only