i am trying to load the distinct values from a specific column of a sQL database table. i am able to get the elements of that column, however i need to get the distinct values without displaying the duplicate ones, how is that possible?
You can apply the GROUP BY clause on the table field: Combo "Field" property: my Field, Database "Table" property: "MyTable GROUP BY MyField" So the full query that Indusoft outputs becomes: "SELECT MyField FROM MyTable GROUP BY MyField"
Another approach is to instead writing "MyField" to the "Field" property of the combo, try writing "DISTINCT MyField". (I'm not sure about this, but certainly SQL functions work that way, for example personally I have used SUM(MyField).
