Sorting

[Mike Matthews - Omnis]

Hello Martin,

If you make L_Name as a National type.  This will then sort it by AaBbCcDd etc.

Mike Matthews

Lineal Software Solutions
Commercial House, The Strand<x-apple-data-detectors://1/1> Barnstaple, Devon, EX31 1EU<x-apple-data-detectors://1/1>

omnis at lineal.co.uk<mailto:mike.matthews at lineal.co.uk>

www.lineal.co.uk<http://www.lineal.co.uk/>

www.sqlworks.co.uk<http://www.sqlworks.co/>



On 28 Dec 2020, at 15:39, Martin Luce via omnisdev-en <omnisdev-en at lists.omnis-dev.com<mailto:omnisdev-en at lists.omnis-dev.com>> wrote:

Hi

I am trying to sort a list alphabetically but not divided between upper and lower case. ie I want a word starting with lower case c to be in the right place amongst all the Cs and not to have the lower case starting letters appearing after all the upper case first letters.

I am using

Do i_InPortLst.$sort($ref.[L_Name])       L_Name being the name of the column to sort on in the list

Have tried

Do i_InPortLst.$sort($ref.[L_Name],upp())
but does not help

Here is to a better New Year for all

Martin
_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com