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