>I have a bunch of variables that i need to insert into a sql table. Is it possible, and if so what is the exact syntax, to use SQLEXEC() and an INSERT statement to put FoxPro variables into a SQL table. I know that working solely with SQL dml syntax you can declare and use variables via the @ character but I'm stuck as to how to use VF variables within the SQLEXEC() statement.

If memory serves...

LOCAL liVar1, lcVar2

liVar1 = 1
lcVar2 = 'Microsoft'

SQLEXEC(lhHandle, "INSERT INTO TableName (?liVar1, ?lcVar2)")