O7 Duplicate values in a list using search
Martin Obongita
martin.obongita at yahoo.com
Fri Feb 17 19:28:13 UTC 2023
Hi All,
This is an Omnis 7 question.
I have the procedure below to search for duplicate records in a list (I found this method in another thread):
---Set current list #L1
Clear sort fields
Set sort field E1_CODE
Sort list
Set search as calculation {(#L1.[#L+1].[E1_CODE]=#L1.E1_CODE)|(#L1.[#L-1].[E1_CODE]=#L1.E1_CODE)}
Search list (From start,Select matches (OR),Deselect non-matches (AND))
Go to next selected line (From start) ---
It does not seem to search the list as expected, for me.
This has led me to look for help here. How do I search for duplicate rows in a list in Omnis 7?
RegardsMartin.
More information about the omnisdev-en
mailing list