Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #10930

Re: Wrong Sort Order of Index

From "Michael Hagl" <haglmi@hagl.de>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Wrong Sort Order of Index
Date 2017-08-25 11:49 +0200
Message-ID <f0aa3vF1f79U1@mid.individual.net> (permalink)
References <d1f59ccc-5ed8-40b0-8cec-55b885373f14@googlegroups.com>

Show all headers | View raw


Hi Jürgen,

I have do some tests: (ADS-12, OEM- und ANSI-Character Set is setting to 
GERMAN),l but xHarbour

Sort result "Upper(text1)" as it should

aaa
aaa-bab
aaa-bbc
aaa-bcb
abc
adb

I dont think that "-" Chr(45) is a special character and charset or 
collation doesn´t matter.

Are you sure that the last char behind aaa ist a space (Chr(32))?

Michael Hagl


"Jürgen Knauf" <trotterklaus@googlemail.com> schrieb im Newsbeitrag 
news:d1f59ccc-5ed8-40b0-8cec-55b885373f14@googlegroups.com...
There is a strange bug in Advantage Database Server 12.

When there is the special Character "-" in a string of a data field with an 
Index,
Advantage Database Server do not find the correct records. The sort order of 
the  index "UPPER(ARTICELNO)" is wrong:

Example:
aaa-bab
aaa-bbc
aaa-bcb
aaa
abc
abd

What can I do?

Jürgen Knauf 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Wrong Sort Order of Index Jürgen Knauf <trotterklaus@googlemail.com> - 2017-08-24 06:04 -0700
  Re: Wrong Sort Order of Index dlzc <dlzc1@cox.net> - 2017-08-24 08:49 -0700
  Re: Wrong Sort Order of Index "Jamal" <noooospam@example.com> - 2017-08-24 15:11 -0400
    Re: Wrong Sort Order of Index "Karl-Heinz" <invalid@invalid.invalid> - 2017-08-25 09:26 +0200
      Re: Wrong Sort Order of Index "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-08-25 15:18 +0200
  Re: Wrong Sort Order of Index "Michael Hagl" <haglmi@hagl.de> - 2017-08-25 11:49 +0200
    Re: Wrong Sort Order of Index Jürgen Knauf <trotterklaus@googlemail.com> - 2017-08-25 03:13 -0700
    Re: Wrong Sort Order of Index "Karl-Heinz" <invalid@invalid.invalid> - 2017-08-25 12:58 +0200
      Re: Wrong Sort Order of Index Jürgen Knauf <trotterklaus@googlemail.com> - 2017-08-25 04:32 -0700
        Re: Wrong Sort Order of Index Jürgen Knauf <trotterklaus@googlemail.com> - 2017-08-25 04:37 -0700
      Re: Wrong Sort Order of Index Jürgen Knauf <trotterklaus@googlemail.com> - 2017-08-25 04:38 -0700
        Re: Wrong Sort Order of Index "Michael Hagl" <haglmi@hagl.de> - 2017-08-25 15:14 +0200
      Re: Wrong Sort Order of Index "Michael Hagl" <haglmi@hagl.de> - 2017-08-25 14:30 +0200
        Re: Wrong Sort Order of Index James Martin <james@northwoodlumber.com> - 2017-08-25 09:16 -0400

csiph-web