Genetic string searches Re: VChar vs VText

[Ruslan Zasukhin]

On 11/30/05 6:51 PM, "Ed Kleban" <Ed at Kleban.com> wrote:

>>     WHERE fld & mask
>> 
>> Is this what you ask for ?
>> 
> 
> What I asked for (and would like to see some day eventually) was:
> 
>>> VField.FindMasked(
>>>     inMask as Integer, inKeep as Integer, inSelection as VSet )
>>>     as VBitSet
>>> 
>>> VField.FindMaskedAsArraySet(
>>>     inMask as Integer, inKeep as Integer, inSelection as VSet  )
>>>     as VArraySet
>>> 
>>> VField.FindFirstMasked(
>>>     inMask as Integer, inKeep as Integer, inSelection as VSet )
>>>      as Integer // Returns RecID
>>> 
>>> High-order bits of the inMask argument would be truncated to the size of the
>>> VField.  The inKeep argument would be one of:
>>> 
>>> EVKeep.includeExactMatches
>>> EVKeep.excludeExactMatches
>>> EVKeep.includePartialMatches
>>> EVKeep.excludePartialMatches
> 
> But if we can do this much sooner in SQL, that's great.

I first of all this should go to SQL

> Perhaps this translates to:
> 
> WHERE "(fld & mask) = mask"         // EVKeep.includeExactMatches
> WHERE "(fld & mask) <> 0"           // EVKeep.includePartialMatches
> WHERE "not ((fld & mask) = mask"    // EVKeep.excludeExactMatches
> WHERE "not ((fld & mask) <> 0)"     // EVKeep.excludePartialMatches
> 
> I would also request that if they are some magic symbols like "|", "^", "-",
> and "~" for OR, XOR, DIFFERENCE, and [1's complement negate] that are also
> already in the kernel and can be enabled along with "&" for AND that it
> would be great to have those as well....

> But I'll happily take what I can get and be a very happy camper if I can use
> "&" in the manner noted above.

This will by C++ rules:

    &   bit and
    |   bit or
    ~   bit xor
    ^   bit no


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