Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #10930
| Path | csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail |
|---|---|
| From | "Michael Hagl" <haglmi@hagl.de> |
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Wrong Sort Order of Index |
| Date | Fri, 25 Aug 2017 11:49:43 +0200 |
| Lines | 44 |
| Message-ID | <f0aa3vF1f79U1@mid.individual.net> (permalink) |
| References | <d1f59ccc-5ed8-40b0-8cec-55b885373f14@googlegroups.com> |
| X-Trace | individual.net x1q/8joehVEEmVA/8r5HFgPFlJjqkw/d6/HCjdKhGtHT+7U545 |
| Cancel-Lock | sha1:x8C9WZnjMXkA7XhBB59HM8YqCac= |
| X-Priority | 3 |
| X-MSMail-Priority | Normal |
| X-Newsreader | Microsoft Outlook Express 6.00.2900.5931 |
| X-MimeOLE | Produced By Microsoft MimeOLE V6.00.2900.6157 |
| X-RFC2646 | Format=Flowed; Original |
| Xref | csiph.com comp.lang.clipper.visual-objects:10930 |
Show key headers only | 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
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