Subject | IBO & Update Trigger Problem |
---|---|
Author | Eric Handbury <ehandbury@hotmail.com> |
Post date | 2003-02-09T21:30:30Z |
Hello,
(IBO4_Hg, BCB6-SP2, FB1.0-796)
I have a problem with triggers and the UPDATE statement generated
by IBO. Here's the scenario:
1) I have a master-detail setup (ACMAIN and ACDETAIL) which is
really a 1-1 mapping.
2) User edits some information on the form which sets the state in
both datasets to dssEdit, and then user hits an Apply button which
does a CommitRetaining.
3) IBO generates and runs the UPDATE code for ACDETAIL. The Update
trigger for ACDETAIL modifies a field in ACMAIN.
4) IBO generates and runs the UPDATE code for ACMAIN, which
overwrites the change done in the ACDETAIL trigger code with the
value in its own buffers. So it basically wipes out the changes done
in the detail update trigger.
I have tried setting the bsBefore/AfterEdit BufferSynchroFlags in
ACMAIN, and have done a ACMAIN->InvalidateRowNum in the ACDETAIL-
which was changed in the Detail update trigger?
Thanks. Eric.
(IBO4_Hg, BCB6-SP2, FB1.0-796)
I have a problem with triggers and the UPDATE statement generated
by IBO. Here's the scenario:
1) I have a master-detail setup (ACMAIN and ACDETAIL) which is
really a 1-1 mapping.
2) User edits some information on the form which sets the state in
both datasets to dssEdit, and then user hits an Apply button which
does a CommitRetaining.
3) IBO generates and runs the UPDATE code for ACDETAIL. The Update
trigger for ACDETAIL modifies a field in ACMAIN.
4) IBO generates and runs the UPDATE code for ACMAIN, which
overwrites the change done in the ACDETAIL trigger code with the
value in its own buffers. So it basically wipes out the changes done
in the detail update trigger.
I have tried setting the bsBefore/AfterEdit BufferSynchroFlags in
ACMAIN, and have done a ACMAIN->InvalidateRowNum in the ACDETAIL-
>AfterPost() with no success.How do I get IBO to use the correct field value in a Master UPDATE
which was changed in the Detail update trigger?
Thanks. Eric.