Hi,

Anybody knows how to select distinct (unique record) records in Baan IV ?

As far as I know the distinct keyword is not supported in Baan IV.

Any help/guidance in this regard will highly be appreciated.

Vishal

Hi,

Please check this similar thread (http://www.baanboard.com/baanboard/showthread.php?t=51980)
Not sure about your version, but on LN there is a function to add a trace on variable using on.change.check() and then sort the selection by using this field.

No distinct available for 4c4, but like bhushan stated you can use on change check or even group by depending on the situation.