My application uses DML caching, and for the Insert case uses
Dataset.RefreshKeys. (Updates use InvalidateBookmark after setting the
bookmark to the Updated Row).

I too would be interested in the most efficient technique.

----- Original Message -----
From: "Lucas Sroka" <L.Sroka@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Thursday, March 07, 2002 9:51 PM
Subject: Re: [IBO] How to refresh only ONE inserted row ?


> my fault - I wasn't clear enough
>
> Quiestion is :
> 1.one TIBODatabase (or TIB_Connection) and one default transaction
> 2. two TIBOQuery components both refrencing the same Interbase table but
> with different SQLs
> 3. one Query inserts new record into table and commits it- how to make
> second query update without calling Refresh (and fetching all rows) - is
DML
> Caching best solution or anybody knows better way ?
>
> Thanks
>
> Lucas Sroka
>
> ""Riho-Rene Ellermaa"" <r.ellermaa@...> wrote in message
> news:EB7F4A56326E97468392D1FB7684CE9C31AEE8@......
> > I propose
> > Dataset->InvalidateRowNum(Dataset->RowNum);
> >
> >
> > Riho-Rene Ellermaa
> > senior programmer
> > Hansabank
> >
> > -----Original Message-----
> > From: Lucas Sroka [mailto:L.Sroka@...]
> > Sent: Thursday, March 07, 2002 10:59 AM
> > To: IBObjects@yahoogroups.com
> > Subject: [IBO] How to refresh only ONE inserted row ?
> >
> >
> > Hello
> >
> > Can anybody share his/her idea on simplest way to refresh only minimal
set
> > of rows after inserting newone using TIODataset family ?
> >
> > greetings
> >
> > Lucas Sroka
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
>
___________________________________________________________________________
> > 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 !
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
>
>
___________________________________________________________________________
> 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 !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>