locate methods for cursor

[Ruslan Zasukhin]

On 6/27/06 4:08 PM, "Sims, John (CDC/NCBDDD/DBDDD) (CTR)" <ayu8 at cdc.gov>
wrote:

>> To clarify. So steps are next?
>> 
>>     curs = db.SqlSelect( "select f1, f2, f3, FROM T1 ..." )
>> 
>>     curs.PrimaryKey = f2    // f2 must have unique values...
>> 
>>     curs.Find( v2 )  // move cursor to record that have in f2
>> value v2.
>>         
>> 
>> Right ?
>> 
>> 
>> --
>> Best regards,
>> 
>> Ruslan Zasukhin
>> VP Engineering and New Technology
>> Paradigma Software, Inc
> 
> Hi Ruslan,
> 
> Yes, that is very much how the .NET Datatable works.  The only thing I
> would point out is that the .NET Datatable allows you to use multiple
> column PrimaryKey by making PrimaryKey an array of Datacolumns.  Using
> your example, it might look more like this.
> 
> Dim pk() as Vfield
> 
> curs = db.SqlSelect( "select f1, f2, f3, FROM T1 ..." )
> 
> Pk.append(f2)
>  
> curs.PrimaryKey = pk    // f2 must have unique values...
> 
> Dim vals() as string
> 
> Vals.append(v2)
> 
> curs.Find( Vals )  // move cursor to record that have in f2 value v2.

I see, but note that we not support multi-column PKs even for Tables.


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