Adding Records at Start

[Ruslan Zasukhin]

on 1/7/04 9:41 PM, Mark Maslowski at mark at majico.com wrote:

>> Is your ID field a string or a number? If it is sorted as you write then it
>> is sorting in alpha order which will sort all records beginning with 1
>> (including 10, 11, etc.), then 2. To get it to sort in numerical order the
>> field needs to be set as short or another numerical field.
>> 
>> Hope that helps.
> 
> 
> Yes, that did help the ordering. However, I still need to find out why the
> DISTINCT is not working with an ORDER BY in the SQL query.

So it was STRING?
And when you have change it to number it give expected order?
Good.


Try simply 
    
    SELECT DISTINCT level_1 FROM resources


I afraid I could loose this combination so we have bug


-- 
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
-------------------------------------------------------------