[adm2-dev] Refresh row --> updateQuery - Forum - OpenEdge Development - Progress Community

[adm2-dev] Refresh row --> updateQuery

 Forum

[adm2-dev] Refresh row --> updateQuery

  • 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

    rlanger.vcf

  • 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