Subject Re: IBO_Transaction Start before first table open
Author Matt Nielsen
Sorry. Probably a beginner mistake. If you don't set the
IB_Connection of the transaction then you get this behaviour.

--- In IBObjects@yahoogroups.com, "Matt Nielsen" <mnielsen@c...>
wrote:
> 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