Ram Prashanth
New Member
I have a smart select in a sdv which is connected to a sdo (relations table in sports2000.db)
How do I get unique relation values from sdo to this smart select.
All the dynamic functions setquerywhere, assignqueryselection just allow us to modify where clause, But I can't think of a condition to add in where clause to get unique values.
I know using break-by and first-of we can get unique results, But I am not sure how to add these conditions to override sdo's query.
Can anyone please help me on this?
Thanks,
Ram.
How do I get unique relation values from sdo to this smart select.
All the dynamic functions setquerywhere, assignqueryselection just allow us to modify where clause, But I can't think of a condition to add in where clause to get unique values.
I know using break-by and first-of we can get unique results, But I am not sure how to add these conditions to override sdo's query.
Can anyone please help me on this?
Thanks,
Ram.
