Sorting numeric

[Roger Amar]

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;