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


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

Re: Wrong Sort Order of Index

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 14:30:56 +0200
Lines 92
Message-ID <f0ajh3F3l9cU1@mid.individual.net> (permalink)
References <d1f59ccc-5ed8-40b0-8cec-55b885373f14@googlegroups.com> <f0aa3vF1f79U1@mid.individual.net> <f0ae74F2dqjU1@mid.individual.net>
X-Trace individual.net iPoHWGawDhDSsVLQ62/gsAoz6hWY5yvEcAcTxAAwZvbWyktH+H
Cancel-Lock sha1:steYPmuOnI6xTbDIVMRzdiO1qzY=
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; Response
Xref csiph.com comp.lang.clipper.visual-objects:10937

Show key headers only | View raw


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 | 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