Sorting numeric

[Ruslan Zasukhin]

On 3/7/05 11:59 AM, "Roger Amar" <Roger at logram.com> wrote:

> Hello folks,
> 
> I am using Valentina on Revolution.
> My database has 2 BaseObjects and I have a sorting problem.
> 
> This SQL sorts numeric by NumVolume as expected :
> "select recID,NumVolume,NomVolume,SupportVolume,EtatVolume,GroupeVolume
> from boVolumes where SupportVolume like '45 TOURS' no_case order numeric
> by NumVolume"

select recID,NumVolume,NomVolume,SupportVolume,EtatVolume,GroupeVolume
from boVolumes 
where SupportVolume like '45 TOURS' no_case
order numeric by NumVolume"
     ^^^^^^^^^
    what is this ???
    

The correct syntax is

    ORDER BY fld1, fld2, ...


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