|
Home > Archive > FoxPro database connector > February 2006 > Index order problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Index order problem
|
|
| GrleREB 2006-02-15, 7:25 am |
| I created an index on a character type field C(80). The problem is that not
all the values are sorted corectly. Fo example 'check-list' is sorted after
the word 'humor' then after 'check-list' there is a word 'chunk' then 'IAC'.
I don't understand and I recreated the index many times without improvement.
My operating system codepage is 1250, the index collating sequence is 'slovak'
Thanx
| |
| Cindy Winegarden 2006-02-15, 11:25 am |
| Hi GrleREB,
This is unusual. What index expression are you using? Just to make sure you
know, the table order doesn't actually change when you add an index, you
have to SET ORDER TO to see the rows in a different order.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
"GrleREB" <GrleREB@discussions.microsoft.com> wrote in message
news:B6BFBB55-DFD6-491D-A564- CB0BCFB33894@microso
ft.com...
>I created an index on a character type field C(80). The problem is that not
> all the values are sorted corectly. Fo example 'check-list' is sorted
> after
> the word 'humor' then after 'check-list' there is a word 'chunk' then
> 'IAC'.
> I don't understand and I recreated the index many times without
> improvement.
> My operating system codepage is 1250, the index collating sequence is
> 'slovak'
>
> Thanx
| |
| GrleREB 2006-02-17, 7:27 am |
| INDEX ON ODREDNICA TAG NAZIV_LEKS OF LEKSVEZA
SET ORDER TO NAZIV_LEKS && ODREDNICA
That's it. The only thing that could cause this problem is maybe the
'slovak' collating sequnece because I found in the VFP help the following
note:
When you specify the SPANISH option, "ch" is a single letter that sorts
between "c" and "d", and "ll" sorts between "l" and "m".
Maybe 'ch' in SLOVAK is sorted between 'h' and 'i' ??????? But where I can
check this ??????
"Cindy Winegarden" wrote:
> Hi GrleREB,
>
> This is unusual. What index expression are you using? Just to make sure you
> know, the table order doesn't actually change when you add an index, you
> have to SET ORDER TO to see the rows in a different order.
>
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@msn
.com www.cindywinegarden.com
>
>
> "GrleREB" <GrleREB@discussions.microsoft.com> wrote in message
> news:B6BFBB55-DFD6-491D-A564- CB0BCFB33894@microso
ft.com...
>
>
>
| |
| Olaf Doschke 2006-02-17, 1:24 pm |
| > INDEX ON ODREDNICA TAG NAZIV_LEKS OF LEKSVEZA
Why "OF LEKSVEZA".
A tag will normally be put in the cdx file named as the table.
So either you need
SET ORDER TO TAG NAZIV_LEKS OF LEKSVEZA
or you leave out OF LEKSVEZA in both commands.
Bye, Olaf.
| |
| GrleREB 2006-02-18, 7:23 am |
| Yes, that's OK but this doesn't solve the wrong sorting when I applay the
right index. Again, I think that the collating sequence is the main problem
but how can I discover how the collating sequence is ordering characters. By
the way, I need the Croatian collating sequence but this one is not appliable
so I picked 'Slovak' instead cause 'Slovak' is the nearest to Croatian that I
found, but maybe it's not near enough.
"Olaf Doschke" wrote:
> Why "OF LEKSVEZA".
> A tag will normally be put in the cdx file named as the table.
> So either you need
> SET ORDER TO TAG NAZIV_LEKS OF LEKSVEZA
> or you leave out OF LEKSVEZA in both commands.
>
> Bye, Olaf.
>
>
>
>
| |
| Olaf Doschke 2006-02-21, 3:24 am |
| > By
> the way, I need the Croatian collating sequence but this one is not
> appliable
> so I picked 'Slovak' instead cause 'Slovak' is the nearest to Croatian
> that I
> found, but maybe it's not near enough.
You gave english words as example, so I wonder why you'd need croatian.
You could have said so initially. Your first question sounded, as if you had
a corrupt index and wanted english collating sequence.
If the slovakian collating sequence is sorting ch in between h and i that
should
be okay to slovakians. If this is not okay for croatians, you can't use that
sequence.
Have some searches for "croatian alphabet", "slovakian alphabet". Wikipedia
should help you. I found that you observation is true: In slovakian ch is a
letter
between h and i. That does not fit croatian. And as there is no croatian
collation
sequence in VFP, I'd go with MACHINE.
Find a croatian foxpro programmer, he/she may be able to tell you what
to use as a workaround.
Bye, Olaf.
|
|
|
|
|