Strange Word Index Behavior

M

mmohrmann

New Member
I have a strange problem concerning word index
We use Progress 9.1C25 but i also tried 9.1D05

I have a simple table (test) with one character field (bez1) and a word
index on that field.

no i create one record with the string "Schonkaffee" in bez1.
When i now do a for each on that table like this:

for each test where bez1 contains "schon":
disp bez1
end.

i'll get no results.

If i use "contains "schonk"" or "contains "schonka"" or
"contains "schonkaffee"" progress finds the record.

if i use "contains "schonkaf"" or "contains "schonkaff"" or "contains "schonkaffe"" progress finds nothing.

Can anyone explain to me why that is happening ?

Maybe you can also explain why progress finds "cafe" in the string "Fließ-Estrich FE 50 Largo 40 kg-Sac"

any help appreciated...

thanks....
 
Contains uses word indexes and therefore the word index rules will determine what Progress sees as the "words" in there.

I can't explain this, only suggest that BEGINS might be a better option at this point.

You would need to review both the code-page and the Word Index rules to sort this one out.

Good luck
 
The Databse uses Code-Page 1252 and GERMAN9 for word breaking.

what do you mean by "word-index-rules" ?

Is there a way to have a look at the word-index Progress has created ?
 
Perhaps I should have said Word Break Rules.

You have specified GERMAN9 - You need to get the details from someone about how GERMAN9 determines what is a word and word terminating characters.

This should tell you how the words are created in the database and from this you should be able to work out why the behaviour is strange.
 
You must log in or register to reply here.
Back
Top