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

Semi-dynamic queries and database security

Discussão em 'StackOverflow' iniciado por fdantas, Março 5, 2019.

  1. fdantas

    fdantas Administrator Moderador

    I know that plain Progress 4GL code with static buffers, find, for each etc. is subject to database security at compile-time (or additionally at run-time with the "Use Runtime Permissions Checking" option).

    Dynamic queries are subject to database security at run-time only.

    Does anyone know how code like in the following example would behave?

    define query q for OrderLine.

    DEFINE VARIABLE hQuery AS HANDLE NO-UNDO.

    hQuery = QUERY q:HANDLE.

    hQuery:QUERY-PREPARE("FOR EACH OrderLine NO-LOCK WHERE OrderLine.Itemnum = 100":U).
    hQuery:QUERY-OPEN().

    get first q.
    do while available OrderLine:

    display OrderLine.Qty.

    get next q.

    end.

    close query q.

    Continue reading...

Compartilhe esta Página