I have no problem changing bill expense line memos but when I run the same sql on the creditcardchargeexpenseline table, I get this error and I'm not sure what this QODBC message means but it looks to me like the driver might be looking to change the creditcardtable instead of the creditcardchargeexpenseline table???

2007-01-18 17:48:33 QODBC Ver:  7.00.00.204 *********************************************************************************************************************
IsAService: False
SQL Statement: UPDATE "CreditCardChargeExpenseLine" SET "ExpenseLineMemo"=? WHERE "FQPrimaryKey" = ?
Error parsing complete XML return string (8)
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="6.0"?>
<QBXML>
    <QBXMLMsgsRq onError = "continueOnError" responseData = "includeNone">
        <CreditCardChargeModRq requestID = "1">
            <CreditCardChargeMod>
                <TxnID>F18ED-1146772354</TxnID>
                <EditSequence>1169142688</EditSequence>
                <ExpenseLineMod>
                    <Memo>sdfsdfasdfsdf</Memo>
                </ExpenseLineMod>
            </CreditCardChargeMod>
        </CreditCardChargeModRq>
    </QBXMLMsgsRq>
</QBXML>

Check the "Review SDK Messages" log in the QODBC Setup Screen for the SDK error why your update is not being excepted.

Here's what it says, but I'm sorry, Idon't know what it means?

20070118.203357 I 848 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 2332).
20070118.203358 I 848 SpecVersion Current version of qbXML in use: 6.0
20070118.203358 I 848 QBSDKMsgSetHandler QUERY: Credit Card Charge
20070118.203358 I 848 QBSDKMsgSetHandler Request 1 completed successfully.
20070118.203358 I 848 MsgSetHandler Finished.
20070118.203358 I 848 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 2332), ret = 0.
20070118.203358 I 848 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 2332).
20070118.203358 I 848 SpecVersion Current version of qbXML in use: 6.0
20070118.203358 I 848 QBSDKMsgSetHandler QUERY: Credit Card Charge
20070118.203358 I 848 QBSDKMsgSetHandler Request 1 completed successfully.
20070118.203358 I 848 MsgSetHandler Finished.
20070118.203358 I 848 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 2332), ret = 0.
20070118.203359 I 848 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 2332).
20070118.203359 I 848 SpecVersion Current version of qbXML in use: 6.0
20070118.203359 I 848 QBSDKMsgSetHandler QUERY: Credit Card Charge
20070118.203359 I 848 QBSDKMsgSetHandler Request 1 completed successfully.
20070118.203359 I 848 MsgSetHandler Finished.
20070118.203359 I 848 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 2332), ret = 0.
20070118.203359 I 848 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 2332).
20070118.203400 E 848 XercesSAXErrorHandler Element 'Memo' is not valid for content model: '(TxnLineID,AccountRef?,Amount?,Memo?,CustomerRef?,ClassRef?,SalesTaxCodeRef?,BillableStatus?)' -- error at line 7, column 127 in XML data.
20070118.203400 I 848 MsgSetHandler Parser error, finishing.
20070118.203400 I 848 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 2332), ret = 1.
20070118.203400 E 2332 RequestProcessor Process Request error = 80042500, There was an error when parsing the provided XML file.
20070118.203400 I 848 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 2332).
20070118.203400 E 848 XercesSAXErrorHandler Element 'Memo' is not valid for content model: '(TxnLineID,AccountRef?,Amount?,Memo?,CustomerRef?,ClassRef?,SalesTaxCodeRef?,BillableStatus?)' -- error at line 7, column 127 in XML data.
20070118.203400 I 848 MsgSetHandler Parser error, finishing.
20070118.203400 I 848 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 2332), ret = 1.
20070118.203400 E 2332 RequestProcessor Process Request error = 80042500, There was an error when parsing the provided XML file.
20070118.203400 I 848 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 2332).
20070118.203401 E 848 XercesSAXErrorHandler Element 'Memo' is not valid for content model: '(TxnLineID,AccountRef?,Amount?,Memo?,CustomerRef?,ClassRef?,SalesTaxCodeRef?,BillableStatus?)' -- error at line 7, column 127 in XML data.
20070118.203401 I 848 MsgSetHandler Parser error, finishing.
20070118.203401 I 848 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 2332), ret = 1.
20070118.203401 E 2332 RequestProcessor Process Request error = 80042500, There was an error when parsing the provided XML file.

The "Error parsing complete XML return string (8)" error has been fixed in QODBC v7.00.00.214, however there is another bug that will be fixed in the next version of QODBC (Build 215 or greater). The flag that should autocopy the ExpenseLineTxnLineID to the Output xml sent to QuickBooks was off a field. The work around before the fix is made is to include the ExpenseLineTxnLineID in the set section as in:

UPDATE "CreditCardChargeExpenseLine"
SET "ExpenseLineMemo"='test', ExpenseLineTxnLineID='4300-1071540741'
where TxnID='42FE-1071540741' and ExpenseLineTxnLineID='4300-1071540741'