At 09:40 PM 18-04-02 +0000, you wrote:

>Hello,
>
> Sorry for the 2nd post, but I really need this answered.
>
>(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.

Something looks funny here. From a client perspective, this isn't a
master-detail setup since there is no detail dataset.

If you set KEYRELATION, that makes your joined dataset "live" in the sense
that any changes to columns in that table will be posted. Changes in
columns derived from other tables won't propagated to the underlying
tables, since the client app has no knowledge of their relationship.

If you want to implement a master-detail relationship, by all means use the
joined dataset as the master, but provide either
- a detail dataset extracted from the detail table and implement
mastersource and masterlinks; or
- stored procedures that are called in the XXXXSQL properties of the
dataset to perform the changes in both underlying tables (and don't define
KEYRELATION).

Apologies if I have misunderstood your setup....also, it's pertinent for
you to mention which data access components you are using.


regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com