I am getting the error "contains unrecognized phrase or keyword" in the following SQLEXEC which is trying to use an ODBC driver to Quickbooks. However I can't seem to get past the VFP error. After several days of messing with this I am about to hoist the white flag.

lnresult = SQLExec(nHnd,[INSERT INTO ;
CheckExpenseLine(AccountRefListID,AccountRefFullName,;
ExpenseLineSeqNo,ExpenseLineTxnLineID,ExpenseLineAccountReflistID,;
ExpenseLineAccountReffullName, ;
ExpenseLineAmount ) ;
values( "80000026-1205231806" ,"test",1,"3-1205232033",;
"8000000C-1205181842","Advertising and Promotion",10) ] )

?lnresult

This is a SQLEXEC using the Qodbc driver to QuickBooks. I can update and get data from the CheckExpenseline table but have not been able to do an insert. I can update,insert and select the customer and vendor tables with no problems so my connection to QuickBooks seems OK.

Thanks in Advance
Gaylen