SQL - INSERT INTO question. 1

[Gweniviere]

Does VFP support this syntax of INSERT INTO?

INSERT INTO MyTable (field_1,field_2,...) SELECT field_1,field_2,... FROM MyOtherTable

I get a syntax error every time I try this command, whether it is performed on local VFP tables or on SQL/MySQL server tables (via SQLEXEC())

After doing a SCATTER MEMVAR I can do a

INSERT INTO MyTable (field_1, field_2,...) VALUES (?m.field_1,?m.field_2,...)

but I have gigabytes worth of data to transer on a fairly regular basis and I would love to simply select the data from the local tables and insert it into the appropriate SQL/MySQL servers tables.

Thanks for any help you can offer.

Gwen

 

[RTorrance]

Gwen
Add the work VALUES after the INSERT INTO MyTable

so it would be INSERT INTO MyTable VALUES () ...

 

[rgbean]

Gwen,
Yes, VFP 8.0 added the

INSERT INTO MyTable (field_1,field_2,...) SELECT field_1,field_2,... FROM MyOtherTable

syntax. It wasn't available in earlier versions.

Rick

 

[Gweniviere]

Rick, thanks for the quick reply. I guess I will have to get the company to spring for VFP 8.0.

Gwen