locate methods for cursor

[Ruslan Zasukhin]

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

Hi John,

> Sorry if I'm a little late to the dance.  I was on vacation.  The .Net
> Datatable (similar in concept to a Vcursor) has a PrimaryKey property as
> an array of DataColumns.  You can then execute a "Find" on the Datatable
> by providing it with the value (or values if you have a multiple column
> PrimaryKey) and it will return the Datarow of the row that matches.  As
> in a database, the PrimaryKey column(s) must contain values that make
> each row unique.  If you attempt to create a PrimaryKey that has
> duplicate data, it will fail.  Perhaps you could do something similar
> with the Vcursor.
> 
> Vcursor.PrimaryKey as Vfield()
> 
> Then Vcursor.Find(Value()) could set the Vcursor to the matching record
> if found or EOF if not found.
> 
> Just my little input.

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

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]