1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

How do I call and get the latest record by clicking on Smart fields and Drop down boxes?

Discussão em 'StackOverflow' iniciado por fdantas, Agosto 25, 2019.

  1. fdantas

    fdantas Administrator Moderador

    Hello OpenEdge/Progress 4GL!!!

    I think I need an idea from you. I have created a smart viewer window and added smart fields,drop down boxes on it. Whenever I click on it then need to call a program(getlatestrecord.p) to get the latest records and fetch.

    The concern here is I don't know how to call a program or call the db from smart fields and drop down boxes to get a latest records once i click on it.

    You might have a question why I need to call a program every time from each smart fields,drop down boxes. This is because record will be updated to db every minute and window will only have initial fetch data when open it.

    Note- More than 2 smart fields and drop down boxes available also it has different records.

    Let me share what i tried from my side.

    /* For fetch the data into drop down box- Its running in main block */

    FOR EACH tt_pipeLine NO-LOCK
    BREAK BY tt_pipeLine.line_key:
    IF FIRST-OF(tt_pipeLine.line_key) THEN
    DO WITH FRAME frMain:
    fi_PipeLineKey:ADD-LAST(tt_pipeLine.line_key).
    END.
    END.

    /* Under Dynamic Lookup - Smart Fields */
    FOR EACH part NO-LOCK INDEXED-REPOSITION
    Key Field: Part_obj
    Displayed field: part_id
    Fieldlabel: PARTS LIST
    Browse title: Lookup


    /* This is a setup that we can do in smart field instant properties*/


    Please advice. It would be better if you provide an small example.

    Continue reading...

Compartilhe esta Página