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

  • Thread starter Thread starter Joey Samoy
  • Start date Start date
Status
Not open for further replies.
J

Joey Samoy

Guest
Hi All, George, can't do word index. Jonathan, the list is built at run time, perhaps I can use array, or temp-table. But still have to do the same logic of validating that all of the items in this list exists in one record. Patrick, let me try again with another example. Record 1 Id A US B CA C UK Record 2 Id A US C UK Record 3 Id Country A US B CA C UK D AU MyList = "A,B" - matches with 1 and 3 MyList = "A,B,C" - matches all MyList = "D" - matches 3 only TIA!

Continue reading...
 
Status
Not open for further replies.
Back
Top