Hello all,
I have two SDO's linked to each other on a window, each one with a viewer
and browse related.
When I delete a record from the child SDO, a database trigger updates the
parent SDO.
In order to visualize the change I call refreshRow in the parent SDO. This
works ok.
However, when the LAST child is deleted, the database trigger deletes the
parent record.
In that case refreshRow moves to a different record but this change in
parent record IS NOT 'SENSED' by the child SDO which shows an empty browse
because the query still points to the old parent.
Which procedure/function do I need to call to forces the query string to be
re-evaluated with the different foreignkey?
Many TIA,
Wim
____________________________
Design, Development, Training
and Implementations in Italy
Tutto in Progress (r) !
(www.progress.com)
Wim van der Ham
Tel: +39 011 4527691
GSM: +39 335 6877283
Fax: +39 335 0 6877283
ICQ: 397259
To unsubscribe, e-mail: dev-unsubscribe@adm2.possenet.org
For additional commands, e-mail: dev-help@adm2.possenet.org
Try one of these
either
OR
run dataAvailable (INPUT 'different':U).
Assuming your links are all ok, by runing one of these options in the parent
sdo "should" tell the child SDO to refresh. if that fails try either option in
the child SDO.
NB: Both of the examples I have, were run from the SDO itself. Therefore if you
run them from some other object (ie a viewer) you will need to provide th
appropriate handle.
HTH
Robert Langer
Consultant, Progress Software Sydney
This message represents my opinion, not that of Progress Software
Wim van der Ham wrote:
Hello all,
>
I have two SDO's linked to each other on a window, each one with a viewer
and browse related.
>
When I delete a record from the child SDO, a database trigger updates the
parent SDO.
In order to visualize the change I call refreshRow in the parent SDO. This
works ok.
>
However, when the LAST child is deleted, the database trigger deletes the
parent record.
In that case refreshRow moves to a different record but this change in
parent record IS NOT 'SENSED' by the child SDO which shows an empty browse
because the query still points to the old parent.
>
Which procedure/function do I need to call to forces the query string to be
re-evaluated with the different foreignkey?
>
Many TIA,
>
Wim
>
____________________________
Design, Development, Training
and Implementations in Italy
>
Tutto in Progress (r) !
(www.progress.com)
>
Wim van der Ham
Tel: +39 011 4527691
GSM: +39 335 6877283
Fax: +39 335 0 6877283
ICQ: 397259
>
To unsubscribe, e-mail: dev-unsubscribe@adm2.possenet.org
For additional commands, e-mail: dev-help@adm2.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@adm2.possenet.org
For additional commands, e-mail: dev-help@adm2.possenet.org
At 19:17 16/05/2002 +1000, you wrote:
>Try one of these
>
>either
>
That could mess up the position in the query.
>OR
>
>run dataAvailable (INPUT 'different':U).
Which is what seems to be the best way, and should have been implemented in
the refreshRow procedure in the first place when the record to be refreshed
is no longer available...
>Assuming your links are all ok, by runing one of these options in the parent
>sdo "should" tell the child SDO to refresh. if that fails try either option in
>the child SDO.
The dataavailable 'different' from the parent SDO should do the trick.
>NB: Both of the examples I have, were run from the SDO itself. Therefore
>if you
>run them from some other object (ie a viewer) you will need to provide th
>appropriate handle.
Yep, but that's the basic stuff
Thanks,
Wim
To unsubscribe, e-mail: dev-unsubscribe@adm2.possenet.org
For additional commands, e-mail: dev-help@adm2.possenet.org