Cursor.FindSingleValue

[Thomas Flemming]

 >     and then in cursor you can do binary search by that field values.

what is "binary search by that field value"  ?




Ruslan Zasukhin schrieb:
> On 12/28/09 4:36 PM, "Thomas Flemming" <tf at ttqv.com> wrote:
> 
>> 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 ;-)
> 
> * better faster to use not .pos =
> But cursor.NextRecord
> 
> 
> * why you need to search cursor?
> 
> * only one field to search?
>     if yes, then may be ORDER BY name
>     and then in cursor you can do binary search by that field values.
> 
> 

-- 
/****************************************
**   Dipl.-Ing. Thomas Flemming
**   Software Development
**
**   Touratech AG
**   Auf dem Zimmermann 7-9
**   D-78078 Niedereschach
**
**   mail  tf at ttqv.com
**   fon   +49 (0) 7728 9279-206
**   fax   +49 (0) 7728 9279-29
**
**   http://www.ttqv.com
**   http://www.touratech.de
**
**   ... und immer dem Pfeil nach!
***************************************/