Hi Eric,

I really re-read your post after sending you a reply, and just on a second
reading I notice that your problem is that you want this kind of join to
work as a lookup. Am I wrong? You want to fill the Masterkey and, still in
edit mode, you want to get the value for Description: you can not do this
with just a query join.

Artur

----- Original Message -----
From: "ehandbury" <ehandbury@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, April 17, 2002 2:18 PM
Subject: Re: [IBO] Joined Datasets, Insert not Refreshing Fields


> Artur,
>
> The MASTERKEY is not a KeyLinks field... its a foreign key for the
> left-joined table. My KeyLinks field is the primary key of the main
> table.
>
> Thanks. Eric.
>
> --- In IBObjects@y..., "Artur Anjos" <arsoft@n...> wrote:
> > Check you KeyLinks prop.
> >
> > Artur
> >
> > ----- Original Message -----
> > From: "ehandbury" <ehandbury@h...>
> > To: <IBObjects@y...>
> > Sent: Wednesday, April 17, 2002 11:42 AM
> > Subject: [IBO] Joined Datasets, Insert not Refreshing Fields
> >
> >
> > > Hello,
> > >
> > > (IBO4.2Gc, BCB4, FB-1.0-796)
> > >
> > > I have a joined dataset:
> > > select D.DESCRIPTION,M.MASTERKEY from MBMASTER M left join
> MBDETAIL
> > > D on D.DETAILKEY=M.MASTERKEY
> > >
> > > I have the KEYRELATION property set so the dataset is live. I
> also
> > > have BufferSynchFlags set to AfterInsert.
> > >
> > > I set the MASTERKEY field value in the OnAfterInsert event, and
> the
> > > problem is that the row does not get refreshed until I do a
> > > Refresh/Post. Is there any way to refresh the dataset after an
> insert
> > > while still remaining in dssInsert mode? I must use a Join since
> the
> > > rows are displayed in a grid.
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
___________________________________________________________________________
> 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 the Yahoo! Terms of Service.
>
>