When I run this even from VB Demo:

update checkexpenseline set expenselinememo = 'hello' where TxnID = '11362F-1181916433' AND ExpenseLineTxnLineID = '113631-1181916433'

I get the error message:

[QODBC] incorrectly built XML from Update start

However, I can update creditcardexpenseline and some others using the same sql.

Querying works fine with this sql below:

select expenselinememo from checkexpenseline  where TxnID = '11362F-1181916433' AND ExpenseLineTxnLineID = '113631-1181916433'

I use Windows XP, optimizer off, QuickBooks 2007 Premier

I love this QODBC. Absolutely love it. Has made my life SOOOO much easier. However, have not been able to update checkexpenseline from the start. This is sure annoying though I am happy as a clam to be able to update other tables.

The approach is correct. I've reported the error to the QODBC Software Engineer under QSupport Ticket ID: BR00000073 for further investigation. There is no time frame set for when I will receive a reply.

I am currently using version 8.00.00.242 and have experienced this problem.  Is there any update to this?  Any other potential workaround?  Thanks.

I would love to be able to run

UPDATE "CheckExpenseLine" SET "ExpenseLineClassRefFullName" = XXXX, "ExpenseLineClassRefListID" = XXXX WHERE "ExpenseLineClassRefListID" is null

Has this error been corrected: QSupport Ticket ID: BR00000073?

I cannot do an UPDATE to the CheckExpenseLine without a [QODBC] incorrectly built XML from Update start error, even though the same UPDATE format is used as for the BillExpenseLine table, which works, (and exactly like your post 4543).  Likewise for the JournalEntry Debit and Credit Line tables?

Also, for the JournalEntry Debit and Credit Line tables, do you have to include all the lines in an entry to not get a balance error to change the Class field for one?