Is there any way to store distinct records in a field or array?
For example: Below query will only store 1 record but if we execute the below query through SQL there are around 10 records.
C+ Select DISTINCT Field1
C+ Into :W0TEST
C+ From FILE1