BitSet operations

[Joakim Schramm]

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Ruslan Zasukhin
> Sent: 09 May 2006 23:40
> To: valentina at lists.macserve.net
> Subject: Re: Re[2]: BitSet operations
> 
> On 5/10/06 12:08 AM, "Joakim Schramm" <joakim at astrocalc.com> wrote:
> 
> >>     FindVlaue -- find EXACT match
> >> 
> > Well it doesn't find an exact match either when more then 1 
> capital in 
> > a word, and otherwise it do find "exact" without caring 
> about case. So 
> > if search is "abds" it also finds "Abds" but not "ABds", if 
> search is 
> > "ABds" it finds "abds", "Abds" but not "ABds"?
> 
> But you talk about CASE INSENSETIVE SEARCH !!!
>  
> You need set correct CollationAttrubute for you database.
> 
>     db.CollationAttribute( kStrength ) = kPrimary
> 
> Check docs please.
> 
Unfortunately I must say this doesn't matter, changing to
db.CollationAttribute( kStrength ) = kPrimary makes no difference, the
results are the same. Sorry, but it is still true - If a string field (first
in record in this case) have a word (string) with 2 or more CAPITAL letters,
the record is totally ignored by FindValue and FindValueAsArraySet AND this
is also true when a numeric field is searched (Byte in this case), the value
simply doesn't exists although it really does. This is VCOM2

Joakim
> 
> > Also, when search in numeric field of records it finds nothing in 
> > records with a string field having more then 1 capital 
> letter in a word.
> > 
> >>     FindStartWith() - find strings that START WITH ...
> >> 
> >> Please check this point.
> >> 
> > I have not used the string functions her as I was interested in an 
> > exact (case less) match and there is no specific string function 
> > returning an exact match so I "assume" FindValue and 
> > FindValueAsArraySet also should work with straings in this case?
> > 
> >> Also note that you can control if db/table/fied should do 
> >> case-sensitive  or case-insensetive searches and sorting. Use for 
> >> this db.CollationaAttribute
> >> 
> > I haven't looked at this one though, guess it is as default, but 
> > should it have any impact on numeric searches? The "main" 
> problem is 
> > that numeric searches also doesn't work if a string field has 2 or 
> > more capitals in same word. With word I mean string field 
> can be like 
> > "Alice Springs" is 2 words, if this is "Alice Springs" no 
> search what so ever work on that record.
> 
> Numeric searches DO NOT depend on collation. Only strings.
> 
> --
> Best regards,
> 
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> 
> Valentina - Joining Worlds of Information http://www.paradigmasoft.com
> 
> [I feel the need: the need for speed]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>