1) DISTINCT doesn�t break editing of data. You just need to add a list of columns from DISTINCT to a WHERE part. DISTINCT breaks master-detail relationship.
I guess you are right. Anyway, IME distinct is useful for selecting single column only, correct? I just somehow fail to see scenario / data model where distinct would be useful with SqlArray. OTOH, it is true that I have mostly self-learned most of data model design (Means: I am quite interested about the real world example of distinct with SqlArray).
Quote:
You already have a tree, which represents an SQL statement. You do not have to parse anything.
Well, in fact, I do not have a tree, I considered that too expensive.
Members
Pages
Help
Register
Login
Home
(Means: I am quite interested about the real world example of distinct with SqlArray).
