That was it. As always thanks Sergey
Gaylen


>A string literal is limited to 255 characters. You can use TEXTMERGE instead
>

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

>>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