>>try putting your sql statement into a variable and execute that way. the problem may be that vfp is asking you to build a string for the sql. if this is direct copy from your prg, should be
>>
>>=sqlexec(lnConnect,"insert into myTable "+;
>> "(field1, field2, field3) values "+;
>> "(val1, val2, val3)" etc...
>>
>I tried storing the sql statement to a variable. The select statement will work by itself, and I'm sure the insert into statement would work if I was supplying values, but when the variable includes the select statement as the values for the insert into, I get an unrecoginized command phrase/keyword error.
>
>I thought SQLEXEC was supposed to run the sql on the server, but it looks like VFP is messing it up.
>
>Any other ideas?
have you tried SQLPREPARE?