Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Provided edit sequence is out-of-date |
Author |
Message |
|
Posted : 2007-08-09 16:33:14 |
I am receiving:
Error: 3200 - The provided edit sequence \"1170657317\" is out-of-date.
When performing an update:
UPDATE InvoiceLine SET InvoiceLineClassRefFullName = 'Employees:Doe, John' WHERE (InvoiceLine.TxnDate>{d '2007-07-01'} And InvoiceLine.TxnDate<{d '2007-07-31'}) AND (InvoiceLine.InvoiceLineServiceDate<{d '2007-07-01'}) AND (InvoiceLine.InvoiceLineClassRefFullName Like 'Employees:Doe, John:Bonus%')
I desperately need to be able to perform this change, and just upgraded from QB 2005/QODB5 to QB 2007/QODBC7 in order to do so only to run into this problem.
I am running version 7.10.00.230.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-08-09 23:22:49 |
Your update spans multiple invoices, so the edit sequence is out-of-date for the second invoice.
You need run:
SELECT TxnID, InvoiceLineTxnLineID for InvoiceLine WHERE (InvoiceLine.TxnDate>{d '2007-07-01'} And InvoiceLine.TxnDate<{d '2007-07-31'}) AND (InvoiceLine.InvoiceLineServiceDate<{d '2007-07-01'}) AND (InvoiceLine.InvoiceLineClassRefFullName Like 'Employees:Doe, John:Bonus%')
and put the query result in a list or table and then create a programming loop to read through the list of TxnIDs and InvoiceLineTxnLineIDs and update each of the InvoiceLines in its own SQL Statement like this:
UPDATE InvoiceLine SET InvoiceLineClassRefFullName = 'Employees:Doe, John' WHERE TxnID = '6130-1197786604' And InvoiceLineTxnLineID = '7133-1197736106' |
|
|
|
|