I'm having trouble updating the ship date in the invoice table using version 7.0.  The same line of code was working fine with version 6.0 so I'm wondering has somthing changed on Quickbooks or the QODBC function I am using called "curdate()"?

VFP Code:

SQLEXEC(gcHand,"UPDATE invoice SET memo = '"+ALLTRIM(man.trknum)+"',shipdate = {fn CURDATE()}  WHERE refnumber = '"+ALLTRIM(man.invnum)+"'")

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.

Tom,

Thanks for the response.  To give you an update, I reversed the fields in my statement to update the shipdate field first then the memo field and it worked. 

New statement:

SQLEXEC(gcHand,"UPDATE invoice SET shipdate = "+{fn CURDATE()}+" , memo = '"+ALLTRIM(man.trknum)+"' WHERE refnumber = '"+ALLTRIM(man.invnum)+"'")

Yes, you are correct:

UPDATE invoice SET shipdate = {fn CURDATE()}, memo = 'Shipdate Test'
WHERE refnumber = 'Discount 2'

works too!

The reason behind this has to do with the order of the columns in the Invoice table:

Memo is after ShipDate and you should always structure INSERT and UPDATE statements in the same order as the columns appear in the table.