BitSet operations

[Ruslan Zasukhin]

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

    FindStartWith() - find strings that START WITH ...

Please check this point.

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



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