Fld.FindSingle problem

[Joakim Schramm]

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Ruslan Zasukhin
> Sent: 18 September 2006 11:53
> To: valentina at lists.macserve.net
> Subject: Re: Re[2]: Fld.FindSingle problem
> 
> On 9/18/06 12:32 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:
> 
> Hi Joakim,
>  
> > Doesn't work! I may need to clearify one thing, it's not that it 
> > doesn't select/return a record, it's that it returns the 
> wrong record. 
> > Also with your code above I get the same result.
> 
> > The table has 3 records with value of sKey,
> >    arrEditBody only has 1, the third of those 3, the result 
> returned 
> > is the first record of table NOT of record set.
> 
> STOP.
> 
> FindSingle() returns RecID of record in table. Right.
> 
> It NOT returns position of record in Set !
> 
> May be you have wrong understanding of how it works?
> 
> 
I don't think so, I want RecID, that's why I use FindSingle BUT I want to
search ONLY the record set returned by my binary link NOT whole table. This
is what happens now, it searches whole table although a limited record set
is passed as second parameter. 

I am doing a test project so it can be seen clearly and tested.

Joakim