Riho,

yes it should be so simple. Have you set the KeyLinks property in
the lookup query properly (the primary key column of Product)?

Regards,
Thomas Steinmaurer
http://www.iblogmanager.com

> -----Original Message-----
> From: Riho-Rene Ellermaa [mailto:r.ellermaa@...]
> Sent: Tuesday, March 26, 2002 11:25 AM
> To: IBObject (E-mail)
> Subject: [IBO] DML Cache for dummies
>
>
> (Sorry if this appears duplicate - previous message dissapeared
> into black hole)
>
> I try to use it in simple application. It has 2 forms - each has
> it's own transaction and query, but share common connection from
> Datamodule. In one form (FProd) user can administer list of
> products ("select name from product"), in another (FMenu) he can
> make daily menus, using combobox for products selection.
> FMenu form contains 2 queries - "select * from menus" and "select
> name from product". The latere is used to populate the combobox.
> If user needs some new product during menu creation, he can open
> FProd and enter new one.
> I want FMenu form's 2. query to know if list is upgraded and
> repopulate the combobox.
>
> I set FProd form's query DMLCacheFlags to Announce and FMenu 2.
> query DMLCacheFlags to Receive. For debugging I created
> OnAnnounce and OnReceive events for both queries. OnAnnounce was
> called but OnReceive was not :(
>
> Is it so simple - just set DMLCacheFlags for both "select name
> from product" queries and they all receive change notifications?
> Or are there some hidden caches? I'm using IBO4.2Fp and BCB5,
> which makes Survey Delphi sample hard to use.
>
> Riho-Rene Ellermaa
> senior programmer
> Hansabank
>
>
> __________________________________________________________________
> _________
> 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/
>
>
>
>