>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
How about this:
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) ] )
Also try to replace double quotes with singles.
Good Luck