DISTINCT Problem (VMD)

[Mark Maslowski]

> Your query look to be right.
> 
> Hmm, try the same query from viSQL.
> 
> Try on other simple db/table with few records only.
> 
> What field type of level_1 ?


I found the problem. It was just Mark being stupid. For some reason I had
the records set to "Indexed by word" instead of "Indexed." Changed them and
it works just fine.

Thanks.

- Mark

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

Mark D. Maslowski
Partner/Designer/Programmer

MAJICo - The Mark and June Interactive Company
Serving Northern California - from Napa to Monterey!
www.majico.com

831-336-3343 voice       831-336-3353 fax

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*