>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)")
Chris McCandless
Red Sky Software