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
anyway.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Lucas Sroka" <L.Sroka@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
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 :
> 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
>