While updating records in a QB File, using VB .NET, this error came up
Incorrectly built XML from Update Start.
ISAMGetData 0x002C89D0 [ISAM] 0x02D92680 [CheckExpenseLine] COLUMN: 34 [ExpenseLineAccountRefFullName] OFFSET: 0 RawXML: FALSE ForceUnoptimized: FALSE DoNotMoveToCache: FALSE UpdateOptimized: FALSE SQL_C_CHAR Petty Cash:Petty Cash - BOS MAX LENGTH: 160 LENGTH RETURNED: 27 NO_ISAM_ERR 00000 00000 ISAMPutData 0x002C89D0 [ISAM] 0x02D92680 [CheckExpenseLine] COLUMN: 40 [ExpenseLineClassRefFullName] SQL_C_CHAR 100 Sales ISAM_BAD_UPD_XML_PUTD S0000 00000 [QODBC] Incorrectly built XML from Update Start. ISAMGetErrorMessage 0x002C89D0 [ISAM] S0000 00000 [QODBC] Incorrectly built XML from Update Start. ISAMCloseTable 0x002C89D0 [ISAM] 0x02D92680 [CheckExpenseLine]
The SQL Command it stopped on was:
"Update CheckExpenseLine set ExpenseLineClassRefFullName = '100 Sales' where ExpenseLineAccountRefFullName = 'Petty Cash:Petty Cash - BOS'"
I have the Read and Write Version of QODBC.
Thanks,
Nachu.
|