Cursor.FindSingleValue

[Ruslan Zasukhin]

On 12/28/09 4:36 PM, "Thomas Flemming" <tf at ttqv.com> wrote:

Hi Thomas,

> I'm trying to get the cursor-position of a specific record with vnet.
> 
> 
> CursorPosition = mCursor.Field("name").FindSingleValue(name1)
> But this always returns the RecID

Wow, :)

I never did know that somebody can try this in such way :)
Yep, API of classes sounds like this is possible.

In fact VField.FindXXXX() methods can be used only for fields of a VTABLE,
But not of VCURSOR.

I think we need add check of this, and throw error in case as yours ...

> When I do it like this, it works, but of course slow on large cursors:
> 
>    For i As Integer = 1 To mCursor.RecordCount
>       mCursor.Position = i
>       If mCursor.Field("name").Value = name1 Then Return mCursor.Position
>    Next
> 
> Where am I wrong ?
> How do I get the cursor.position of a specific record fast ;-)

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