That's interesting, you must have an older version of v6 because if I try any of the below with QODBC v6.00.00.176 or v7.00.00.199:
UPDATE invoice SET memo = 'Shipdate Test', shipdate = ({fn CURDATE()}+430) WHERE refnumber = 'Discount 2'
UPDATE invoice SET memo = 'Shipdate Test', shipdate = {d'2008-01-14'} WHERE refnumber = 'Discount 2'
UPDATE invoice SET memo = 'Shipdate Test', shipdate = {fn CURDATE()} WHERE refnumber = 'Discount 2
I get a 'ShipDate' is not valid for content model:' error:
20061024.160130 I 2616 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 484). 20061024.160130 E 2616 XercesSAXErrorHandler Element 'ShipDate' is not valid for content model: '(TxnID,EditSequence,CustomerRef?,ClassRef?,ARAccountRef?,TemplateRef?,TxnDate?,RefNumber?,BillAddress?,ShipAddress?, IsPending?,PONumber?,TermsRef?,DueDate?,SalesRepRef?,FOB?,ShipDate?,ShipMethodRef?,ItemSalesTaxRef?, Memo?,CustomerMsgRef?,IsToBePrinted?,CustomerSalesTaxCodeRef?,((InvoiceLineMod|InvoiceLineGroupMod))*)' -- error at line 7, column 143 in XML data. 20061024.160130 I 2616 MsgSetHandler Parser error, finishing. 20061024.160130 I 2616 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 484), ret = 1. 20061024.160130 E 484 RequestProcessor Process Request error = 80042500, There was an error when parsing the provided XML file.
I have reported the error to the QODBC Software Engineer and will update this post when a response has been received.
|