Thanks Helen

actually i tried using that function (InsertBufferBookmark - specified in
Help - OnDMLCacheReceivedItem)

i also tried using DefaultDMLCacheReceivedItem function in my query's
OnDMLCacheReceivedItem event but what i see ( with TIB_Monitor ) is
TIB_Query fetches all record from server again(while ItemType.is ditInsert)

and what i want is just fetch only required record ( whose id is specified
in ADMLCacheItem )


Regards
Kamlesh

----- Original Message -----
From: "Helen Borrie" <helebor@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Sunday, July 13, 2003 4:41 AM
Subject: Re: [IBO] How to insert or delete record to TIB_Query's


> At 04:57 PM 12/07/2003 +0530, you wrote:
> >Dear Friends,
> >
> >how to insert or remove record directly to and from the record buffer of
> >TIB_Query
> >
> >when any user insert , update or delete any records my application gets
an
> >message regarding that operation with ID ( key field value - PK) of that
> >record.
> >
> >now how can i refresh just that perticular record using that Record
ID(PK) ,
> >so that query doesnt have to fetch all records ( or keys ) to just to
> >refresh one(inserted or deleted) record
>
> Kamlesh,
> A sample OnDMLReceivedItem handler is included in the Help, under the
topic
> OnDMLReceivedItem. The technique here is to use the KeyValues property of
> the DMLCacheItem to find the bookmark of the affected row in the buffer
and
> invalidate/delete/insert it appropriately.
>
> Helen
>
>
>
>
>
___________________________________________________________________________
> 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/
>
>