[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Find records that has all items in the list

[LarryDusch]

Based on what you've said the data structure is in the table, I'm assuming you have a comma separated list in the table and you have a comma separated list for your query. Try this: def var has_all as logical no-undo. def var i as int no-undo. ... other defs .... readloop: for each mytable no-lock: has_all = true. chkloop: repeat i = 1 to num-entries(myquerylist): if lookup(entry(i,myquerylist),mytable.fieldtocheck) = 0 then do: has_all = false. leave chkloop. end. end. if has_all = false then next readloop. .... do it has all of them stuff .... end.

Continue reading...