DISTINCT Problem (VMD)

[Ruslan Zasukhin]

on 11/24/03 1:54 AM, Mark Maslowski at mark at majico.com wrote:

> I am attempting to query just the unique entries (eliminating duplicates) in
> a column named "level_1" from a table called "modules." I am using this code
> in D8.5 -
> 
>  set SQLString = "SELECT DISTINCT level_1 FROM modules"
>  set gmenuCursor = new(xtra "VCursor", GetRef(gDB), SQLString)
> 
> Unfortunately, this returns ALL records, not just the unique ones. What am I
> doing wrong? I've never used DISTINCT before - is it a syntax problem?

Hi Mark,

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 ?


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------