Subject | IBO_Transaction Start before first table open |
---|---|
Author | Matt Nielsen |
Post date | 2004-02-23T17:21:09Z |
I have found a problem I beleive with the IBOQuery.Open.
Here is the scenerio:
TForm with a TIBODatabase, TIBOTransaction and a IBOQuery with a
simple select statement and RequestLive to true.
I have a button that when clicked performs the following:
MyTransaction.StartTransaction;
Query1.Open;
If I look at the MyTransaction.InTransaction after the table open
then it is false!!!
So I tried another scenerio. I moved the start transaction to after
the open and then placed another TIBOQuery on the form and did the
following in the button click:
Query1.Open;
MyTransaction.StartTransaction;
Query2.Open;
If I look at the MyTransaction.InTransaction after the Query2.Open it
is true.
The problem seems to be if there are no tables currently open when
you start the transaction then you transaction must be started after
the open but at that point you are fine.
This causes me serious greef what can I do to work around this issue
or is there a fix?
I can send a sample app if needed.
Thanks,
Matt Nielsen
Here is the scenerio:
TForm with a TIBODatabase, TIBOTransaction and a IBOQuery with a
simple select statement and RequestLive to true.
I have a button that when clicked performs the following:
MyTransaction.StartTransaction;
Query1.Open;
If I look at the MyTransaction.InTransaction after the table open
then it is false!!!
So I tried another scenerio. I moved the start transaction to after
the open and then placed another TIBOQuery on the form and did the
following in the button click:
Query1.Open;
MyTransaction.StartTransaction;
Query2.Open;
If I look at the MyTransaction.InTransaction after the Query2.Open it
is true.
The problem seems to be if there are no tables currently open when
you start the transaction then you transaction must be started after
the open but at that point you are fine.
This causes me serious greef what can I do to work around this issue
or is there a fix?
I can send a sample app if needed.
Thanks,
Matt Nielsen