Normal Topic [Solved] Sorting (Read 384 times)
wildwood
Full Member
***
Offline


No personal text

Posts: 156
Location: New York
Joined: Apr 2nd, 2004
[Solved] Sorting
Oct 23rd, 2007 at 1:41am
Print Post Print Post  
Solution: Remove colons from field names

I converted an application to the new version from 1.14. My application has two forms. One form can be sorted based on any field but my other form is kind of frozen into a purely alphabetical order on one field.... "Client". If I seek a sort on "Cities", for example, it will produce the clients in alphabetical order and not the "Citiies". The same applies to any field in my form......it will retieve what ever I ask for but not based on my sorting (field?)parameter.

Peter
« Last Edit: Oct 25th, 2007 at 7:03pm by Hammer »  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Sorting
Reply #1 - Oct 23rd, 2007 at 3:06pm
Print Post Print Post  
Hello Peter,

Could you send me the DB and DAT files that you are having this problem with to support@lantica.com so I can have a look at them and see why they are not sorting correctly?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Sorting
Reply #2 - Oct 24th, 2007 at 5:49pm
Print Post Print Post  
Hello Peter,

The problem is that your field names have Colons in them. If you change these using the Field Manager in Sdesigner, Sorts will work correctly for you.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged