FindValueAsArraySet ordering

[Ruslan Zasukhin]

On 12/16/05 6:10 AM, "Ed Kleban" <Ed at Kleban.com> wrote:

> Hi Ruslan,
> 
> I know we've talked about FindLinked, but I don't recall if I've asked about
> FindValueAsArraySet with an inSet argument.  If so I can't find the answer
> in my email history.
> 
> 
> If I call FindValueAsArraySet with an inSet argument, what is the order of
> the elements in the result?
> 
> Examples seem to work best for us in these discussions:
> 
>     matchValue = 69
>     checkSet = VArraySet with: { 5, 1, 4, 3 }
>     someField has values:
> 
>     Rid     someField
>     1       69
>     2       69
>     3       69
>     4       69
>     5       21
>  
>     resultVArraySet = someField.FindValueAsArraySet( matchValue, checkSet )
> 
>     
> Does resultVArraySet = { 1, 4, 3 }
> 
> or 
> 
> Does resultVArraySet = { 1, 3, 4 }

You know, problems...

As I see FindValueAsArraySet() expect to see CheckSet to be only BitSet.

That was enough for our SQL engine...
But of course in ideal we should support ArraySet also. This have sense.

And result will be 
    for ArraySet { 1, 4, 3 }

    for BitSet { 1 3 4 }

Because algorithm just iterate set forward.


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