[Stackoverflow] [Progress OpenEdge ABL] Semi-dynamic queries and database security

[idspispopd]

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...