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 22:44
> To: valentina at lists.macserve.net
> Subject: Re: Re[2]: BitSet operations
> 
> On 5/9/06 8:30 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:
> 
> > I have done some further tests and think I have found it and I am 
> > pretty sure I can say this is a bug. I am trying to define 
> the exact 
> > condition for how this to accure but is not sure yet as I couldn't 
> > complete my tests (see below). However it seem to do with when a 
> > record only have few and probably whole word in Capitals as 
> one part of it's name. Some examples.
> > 
> > There is a place named "Altona", then there is another 
> named "Altona 
> > WA", Altona is found but NOT Altona WA
> > 
> > There are many Altona in my database, 2 just as Altona (both found) 
> > but about 15 Altona + 2 letter abbrivation like IL, MN etc. 
> of which 
> > none is found. Also a place called Altona VIC or Altona 
> North VIC are not found.
> > 
> > However, there is also Hamburg-Altona and Hamburg-Altona 
> KH, the first 
> > is found but not the second.
> > 
> > I experiment little to reproduce it, there is a place 
> called Baulkham 
> > Hills, which is found. I add a copy and name it Baulkham, 
> also found. 
> > I add one more copy Baulkham PA, not found. I add Baulkham 
> Hills PA, 
> > not found. I change Baulkham Hills PA to Baulkham Hills PAP, not 
> > found, and to Baulkham Hills PAPA, still not found. I now 
> got the idea 
> > that the CAPITAL letters of whole word caused problem. I changed 
> > Baulkham Hills PAPA to Baulkham Hills Papa, FOUND! Also Baulkham Pa 
> > now found with same change. So FindValue don't like when a word in 
> > field is all Capital letters. But is this all? No. I now change 
> > Baulkham Hills Papa to Baulkham Hills PApa, again NOT 
> found. I change Baulkham Pa to Baulkham PaP, this also not found.
> > 
> > Conclusion, FindValue and FindValueAsArraySet don't like 
> when a world 
> > contains more then 1 capital letter, it make it blind, and 
> the whole 
> > record is missed so values in other fileds like integers cannot be 
> > found as well. I can't say if this only is for special condition in 
> > structure or not but I also tried to remove all links, 
> which I think 
> > before was the problem but it did not change it, so it was not the 
> > problem. You can see exact structure of database in project 
> I sent before, I changed nothing there.
> 
> >From fast read of your letter it sounds like you confuse
> 
>     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"?

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.

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