[Stackoverflow] [Progress OpenEdge ABL] Is it good to use LOOKUP in FOR EACH WHERE clause? - Progress 4GL

[Bharat]

Is it good if we use lookup function in for each where clause? Will it cause performance issue? Please help to understand and provide the example how to avoid.

define variable cGroupID as character no-undo.

for each <table> no-lock where lookup(cGroupID,<table.fieldname>) <> 0:
   **do something...**
end.
note - table field name can have multiple comma separated group

Continue reading...