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
|
|
[QODBC] Error: 3175 The transaction could not be locked. It is in use by another user |
Author |
Message |
|
Posted : 2007-05-16 08:35:22 |
I get "transaction could not be locked" error whenever I add an invoice line while QuickBooks has invoice form opened. What is frustrating that it can be any invoice - not related to the one that I am trying to update.
Is that expected behavior? If yes - what is the recommended workaround?
Thank you
----------- QB2007 Pro + evaluation of the latest QODBC driver
Full error:
[QODBC] Error: 3175 - There was an error adding, modifying or deleting 45E6-1071528960 because it is already in use. QuickBooks error message: The transaction could not be locked. It is in use by another user
SQL that I am trying to execute
INSERT INTO InvoiceLine (TxnID, InvoiceLineDesc) VALUES ( '45E6-1071528960', 'Tracking #: 798174693420' ) |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-05-16 23:43:31 |
This is QuickBooks locking, simply close the customer you are invoicing or the invoice you are adding lines to in the QuickBooks UI. Normally QODBC application connect to QuickBooks in unattended mode where QuickBooks runs as a background process. |
|
|
|
|
Posted : 2007-05-17 01:53:51 |
>This is QuickBooks locking, simply close the customer you are invoicing or the invoice
OK, so this is expected for any version of Quickbooks, right? What are you saying is that editing single invoice always locks the whole Invoice/InvoiceLine table? Is there a way to check if the table is locked without executing UPDATE ? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-05-17 02:37:28 |
No, instead you need check if you are returned any errors when you do your insert (or update). |
|
|
|
|