Sorting

[David Barnett]

Worse case is to add a column, write an all upper or lower case copy of the name column and sort on that.


David Barnett                 David at FairLibertysCall.com
C: 516-398-8668               www.FairLibertysCall.com

> On Dec 28, 2020, at 10:52 AM, Mike Matthews - Omnis <omnis at lineal.co.uk> wrote:
> 
> 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
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com