Sorting numeric

[Roger Amar]

Fred, you are a very great "copain" !!!
I will dedicate to you my next Brassens listening !
What put me in trouble is that the "sort numeric" was working with an SQL and not with the other, while both fields types were set to "long".
Thank you again, Fred.

Roger;


-----Message d'origine-----
De : valentina-bounces at lists.macserve.net [mailto:valentina-bounces at lists.macserve.net] De la part de Fred.Stephenson
Envoyé : lundi 7 mars 2005 12:01
À : Valentina Developers
Objet : Re: Sorting numeric

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
_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina