DISTINCT not working - varchar

[Ruslan Zasukhin]

On 6/20/10 5:13 PM, "Kay C Lan" <lan.kc.macmail at gmail.com> wrote:

Hi Kay,

Is field marked as IndexedByWords?
 
> simple SQL query:
> 
> SELECT DISTINCT category FROM products
> 
> returns every single row, all category returned multiple times.
> 
> Tested in VStudio 4.5 and same result.
> 
> Searching the List I see Christian reported getting Errors 1 year ago when
> doing DISTINCT on varchar fields. My  field is varchar but I don't get an
> error I just get exactly the same result as if I'd done:
> 
> SELECT category FROM products
> 
> Did a quick test on unsigned short and date field and got correct results.
> 
> Is there some trick to doing DISTINCT on varchar fields?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]