Hi
I use C++ Builder 4.0 with SAPDB by ODBC (ver 7.4.3.30).
I have serious problem during transaction. Sometimes when I try to
update one record in a table using TQuery component it last too much time
(several minutes). It finish successfully but I think that it is too long
time for updating one record.
As the resault my application does not responding several minutes.
I will be grateful for all opinions and advices because it is very
important for me to find reasons of this abnormal behaviour. I have to
resolve this problem to continue developing my application.
More details:
I use only two TQuery components (for expamle TQuery1 and TQuery2).
1. I start transaction.
2. I execute several UPDATE and SELECT instructions in this transaction
using both TQuery objects.
3. I SELECT one record from the Table1 using TQuery1.
4. I try to UPDATE one record in the Table2 using TQuery2. (it last several
minutes)
5. I commit transaction
Table1 is a different table then Table2
But if we delete step 3. everythimg is ok.
1. I start transaction.
2. I execute several UPDATE and SELECT instructions in this transaction
using both TQuery objects.
3. I try to UPDATE one record in the Table2 using TQuery2. (it executes very
quickly. OK)
4. I commit transaction
--
Andrzej Kazmierkiewicz
Remedium
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
