I read a post on the forum that said you will add select distinct in the future for Editor when you are viewing but not updating data. Has that been implemented yet?
Please let me know.
Janet
No - we haven't implemented it as we don't support GROUP BY on the Editor data get. Therefore, the rows must already be unique (since they will have a unique primary key value so they can be addressed when writing back to them).
What is your use case here? Are you just reading values and not wanting to write to the database? In which case, querying the database with SQL directly rather than going through the Editor libraries would provide far more flexibility for you.
Answers
Hi Janet,
No - we haven't implemented it as we don't support GROUP BY on the Editor data get. Therefore, the rows must already be unique (since they will have a unique primary key value so they can be addressed when writing back to them).
What is your use case here? Are you just reading values and not wanting to write to the database? In which case, querying the database with SQL directly rather than going through the Editor libraries would provide far more flexibility for you.
Allan