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

  • Thread starter Thread starter Bharat
  • Start date Start date
Status
Not open for further replies.
B

Bharat

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

Code: 
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...
 
Status
Not open for further replies.
Back
Top