Subject Re: [IBO] Joined Datasets, Insert not Refreshing Fields
Author ehandbury
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.