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
|
|
ODBC4 transaction problems |
Author |
Message |
|
Posted : 2007-03-02 16:06:19 |
We are using ODBC4 to post invoices from an SQL db back to Arrow Dataflex. We have found that large invoices (eg with around 20 transaction lines and up) often don't post correctly. Even after multiple attempts to post they have to be completed manually in Arrow.
Is there a maximum size or number of lines per transaction that ODBC can handle? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-03-02 18:17:39 |
There are FlexODBC users out there that post over 6,000 transactions daily, so 20 inserts represents no problem. Are you sure your INSERTs have all the correct values for all the index keys in the table? When creating a new record you also need to comply with the specification and design of the application.
FlexODBC also doesn't have transaction support, each record is created in real time using an INSERT statement. |
|
|
|
|