When I do:

update purchaseorderline set vendormsg='download'  where refnumber='1005'

I receive the Error: 3200 - The provided edit sequence "1137434359" is out-of-date.

When doing updates to tranasaction tables a WHERE clause something like:

WHERE TxnID = '2A97-1071506491' AND PurchaseOrderLineTxnLineID = '2A99-1071506491'

is normally used to correctly identifly the transaction line. The TxnID allows for indexed jumpins (speed) and the TxnLineID allows you to update one line at a time in a loop getting the new EditSequence number each time.

Internally QODBC updates one line at a time but the edit sequence is listed in the header and gets updated with each update. This error normally indicates a bug in QODBC that needs to be reported to us.

We are getting an error when doing an "update" because we need to change the class on selected transactions.  Everything seems to "update"

Here is a sample of my update:

Because I am updating the "detail" lines, and not the header, what can I do to fix this problem - it gives me a message box for every transaction I am reading and updating.  Thanks for your suggestions.

Vic

Try doing the update at the line by line level:

Update CreditCardCreditExpenseLine set ExpenseLineClassRefFullName = '" & strclass & "'
where TxnID = '" & strID & "' and ExpenseLineTxnLineID = '" & strLineID & "'

I use the following statement: (actual data has been replaced with xxx so to protect the customer id)

Update Customer SET CompanyName = 'xxx',BillAddressAddr1 = 'xxx',BillAddressAddr2 = 'xxx',BillAddressAddr3 = '',BillAddressAddr4 = '',BillAddressCity = 'xxx',BillAddressState = 'xx',BillAddressPostalCode = 'xxxxx',BillAddressCountry = '',ShipAddressAddr1 = 'xxx',ShipAddressAddr2 = 'xxx',ShipAddressAddr3 = '',ShipAddressAddr4 = '',ShipAddressCity = 'xxx',ShipAddressState = 'xx',ShipAddressPostalCode = 'xxxxx',ShipAddressCountry = '',Phone = '',Fax = '',TermsRefFullName = 'Credit Card',Contact = 'xxx',Email = 'xxx'  WHERE Listid = '80001D6A-1235061382'

 And get the following error:

 [QODBC] Error: 3200 - The provided edit sequence "1235061382" is out-of-date.

My routine has been working just fine for about a year now.  This error just started today.

The only info I can find on the forum is:

"Internally QODBC updates one line at a time but the edit sequence is listed in the header and gets updated with each update. This error normally indicates a bug in QODBC that needs to be reported to us."

Please consider this bug reported.  Has it been fixed in the V9 drivers?

I would be more inclined to do:

SELECT * from Customer WHERE Listid = '80001D6A-1235061382'

first!