Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #10938
| From | "Michael Hagl" <haglmi@hagl.de> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Wrong Sort Order of Index |
| Date | 2017-08-25 15:14 +0200 |
| Message-ID | <f0am5jF47vsU1@mid.individual.net> (permalink) |
| References | <d1f59ccc-5ed8-40b0-8cec-55b885373f14@googlegroups.com> <f0aa3vF1f79U1@mid.individual.net> <f0ae74F2dqjU1@mid.individual.net> <505743cc-e730-4a81-a725-3679086c7d59@googlegroups.com> |
Hi,
I have done some tests.
When change collation to ADS_ANSI "AdsSetCharType(ADS_ANSI)" and do a
reindex, I get the same result with wrong sorting order and unwanted seek
result.
Maybe the ads sorting order can be changed by function AdsSetCollation(),
see ADS help file?
Michael Hagl
"Jürgen Knauf" <trotterklaus@googlemail.com> schrieb im Newsbeitrag
news:505743cc-e730-4a81-a725-3679086c7d59@googlegroups.com...
Am Freitag, 25. August 2017 12:58:47 UTC+2 schrieb Karl-Heinz:
> 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
I tried with SetCollation(#CLIPPER).
But the same problem.
Search:
cSuche = "aaaa"
lFound := oglServer:Seek(Upper(cSuche))
result:
lFound => true
found record => aaa-bab
It only works with oglServer:Seek(PadR(Upper(cSuche),30)).
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