Sorting numeric

[Fred.Stephenson]

Salut "Les Copains d'abord"

Roger, although I don't use Revolution , I would imagine that you 
need to remove the "numeric" from both of your select statements.
As your fields are defined as 'long' they should sort as 'long' (nombre).
a+

Fred

>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"
>
>This one sorts numeric by recID, not by NumeroVolume :
>"select
>recID,Titre,Interprete,Auteur,Orchestre,Type,Categorie,Origine,Version,N
>umeroVolume from boTitres where Interprete like 'brassens' no_case order
>numeric by NumeroVolume"
>
>Fields type of NumVolume and NumeroVolume are both set to long.
>
>What is wrong in my SQLs ?
>
>Thanks for your help,
>
>Roger;
>
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina


-- 
Great Britain was given
  God to Save the Queen
and
the NHS to kill her subjects
[Fred Stephenson August 27 2004]

J T Stephenson died Nov. 23rd 2004
cause of death :
Gross negligence and incompetence