Subject Re: [IBO] Please help - can CommitAction := caFetchAll solve it?
Author Andreas Bednarek
Uhh, does that mean TIBOTable.Open creates a view in the database? I would
expect that for TIBOQuery... (I'm not very experienced how exactly views
work so I hope I don't mess the terms now...) However, it seems that things
are getting complicated, as I said in my previous post, refresh over a large
dataset (view?) drastically decreases performance so I probably can't use
it... :-(
Andreas


----- Original Message -----
From: "Lester Caine" <lester@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, April 21, 2004 11:50 AM
Subject: Re: [IBO] Please help - can CommitAction := caFetchAll solve it?


> Andreas Bednarek wrote:
>
> > I try to solve why after a record is inserted to a dataset it is not
> > immediately visible when reading it. AutoCommit is true for all my
TIBOTable
> > components.
> >
> > In some parts of my application it is necessary to see always the most
> > actual content of the datasets. I tried to set caFetchAll for the
> > CommitAction property and it seems it helped, but I in fact don't know
what
> > this value does.
>
> You will need to 'Refresh' any views of the data so that the other
> Tables see the changes. Commit action makes it available to be viewed,
> but until a view is refreshed it will not automatically show the new data.
>
> This is an area where 'Events' can be useful. An event tells you that a
> record has changed, and all programs monitoring that event then know to
> refresh their views. But the crud way of doing this is just to refresh
> on a timer event.
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>