Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #10939
| From | James Martin <james@northwoodlumber.com> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Wrong Sort Order of Index |
| Date | 2017-08-25 09:16 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <onp7o7$inl$1@dont-email.me> (permalink) |
| References | <d1f59ccc-5ed8-40b0-8cec-55b885373f14@googlegroups.com> <f0aa3vF1f79U1@mid.individual.net> <f0ae74F2dqjU1@mid.individual.net> <f0ajh3F3l9cU1@mid.individual.net> |
But space is ascii 32 and dash is ascii 45.
James
On 2017-08-25 08:30 AM, Michael Hagl wrote:
> Hi Karl-Heinz,
>
>
>> #Windows
>>
>> aaa-bab
>> aaa-bbc
>> aaa-bcb
>> aaa
>> abc
>> abd
>>
>> But there might be another problem.No matter if the index is created using
>> #clipper or #windows a seek shouldn´t fail. Maybe later on, after creating
>> the index, Jürgen switches from #windows to #clipper ? Didn´t try that,
>> but
>> i guess that a seek fails - maybe not always - in such cases ?
>>
>
> At this sorting order a softseek for "aaa" and find aaa-bab is IMHO correct.
> The fist occurence of "aaa" has been found. I think, this sorting order is
> wrong. This collation sorts the "-" before the Space
>
> Michael Hagl
>
>
> "Karl-Heinz" <invalid@invalid.invalid> schrieb im Newsbeitrag
> news:f0ae74F2dqjU1@mid.individual.net...
>> Hi Michael,
>>
>>> I have do some tests: (ADS-12, OEM- und ANSI-Character Set is setting to
>>> GERMAN),l but xHarbour
>>
>> i made a small VO-Test. Depending on that code i get these results:
>>
>> FUNCTION Start()
>> LOCAL oDB AS DBServer
>> LOCAL cPfad AS STRING
>>
>>
>> // makes no differences if sortorder.dbf ist a OEM-Dbf or not
>>
>> // SetCollation ( #windows )
>> SetCollation ( #clipper )
>>
>> RddSetDefault ( "DBFCDX" )
>>
>> cPfad := "D:\test\"
>>
>>
>> IF File ( cPfad + "SOrtorder.cdx" )
>> FErase ( cPfad + "SOrtorder.cdx" )
>>
>> ENDIF
>>
>> oDB:= DbServer { cPfad + "SOrtorder.dbf" }
>> oDB:Createorder ( "OrderID", cPfad + "SOrtorder.cdx", "Upper(ID)" )
>>
>> oDB:Close()
>>
>> RETURN NIL
>>
>>
>> #clipper
>>
>> aaa
>> aaa-bab
>> aaa-bbc
>> aaa-bcb
>> abc
>> abd
>>
>>
>> #Windows
>>
>> aaa-bab
>> aaa-bbc
>> aaa-bcb
>> aaa
>> abc
>> abd
>>
>> But there might be another problem.No matter if the index is created using
>> #clipper or #windows a seek shouldn´t fail. Maybe later on, after creating
>> the index, Jürgen switches from #windows to #clipper ? Didn´t try that,
>> but
>> i guess that a seek fails - maybe not always - in such cases ?
>>
>> regards
>> Karl-Heinz
>
>
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous 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