Subject | Joined Datasets, Insert not Refreshing Fields |
---|---|
Author | ehandbury |
Post date | 2002-04-17T06:08:44Z |
Hello,
(IBO4.2Gc, BCB4, FB1.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 set the KEYRELATION=MBMASTER so I get a live dataset.
The problem is that in the OnAfterInsert event I set the MASTERKEY
field, but D.DESCRIPTION field is not updated in the dataset until I
do a Refresh. Is there any way to refresh the join while still in
insert mode?
TIA. Eric.
(IBO4.2Gc, BCB4, FB1.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 set the KEYRELATION=MBMASTER so I get a live dataset.
The problem is that in the OnAfterInsert event I set the MASTERKEY
field, but D.DESCRIPTION field is not updated in the dataset until I
do a Refresh. Is there any way to refresh the join while still in
insert mode?
TIA. Eric.