Subject Re: [IBO] How to refresh only ONE inserted row ?
Author Jason Wharton
I see that this is between two datasets... that changes things.

Yes, DML caching is exactly what you need to use here. Although internally
it will still do a RefreshKeys to bring in the newly inserted record. I have
some plans on how to do this more efficiently in the future but I'm not
there yet. If the dataset is small it should be a very efficient operation

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Lucas Sroka" <L.Sroka@...>
Newsgroups: egroups.ibobjects
To: <>
Sent: Thursday, March 07, 2002 5:17 AM
Subject: [IBO] How to refresh only ONE inserted row ?

> my fault - I wasn't clear enough
> Quiestion is :
> 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
> Caching best solution or anybody knows better way ?
> Thanks
> Lucas Sroka