RecID from Cursor

[Chuck Pelto]

Okay....

Suppose I'm not SELECTing on RecID.

I'm selecting on other data in the table.

How do I get the record ID in that scenario?

Example:

SELECT * FROM table1 WHERE field1 = "foo"

What is the call to get the record ID for the record the cursor ends up 
looking at, the SQLSelect() call comes up with anything?

Regards,

Chuck


On Feb 15, 2005, at 12:39 PM, Ruslan Zasukhin wrote:

> On 2/15/05 9:37 PM, "Chuck Pelto" <cbpelto at pcisys.net> wrote:
>
>>>   curs = db.SqlSelect( SELECT RecID, ... FROM T )
>>>
>>>    curs.ULongField( 1 ).value
>>
>> It might be. But it certainly isn't (1) blatantly obvious to the 
>> casual
>> observer [or SQL neophyte] and (2) in the V4RB Reference Manual.
>
> It depend only on your SECLECT list
>
>     SELECT f1, f2, RecId
>
> Then
>
>     curs.ULongField( 3 ).value
>
>
>> Might want to add a call that it's a bit more easily recognized, e.g.,
>> curs.Field("rec_id").Value and put it in the reference manual under
>> Class VCursor. Or curs.GetRecID(), as in the Class VBaseObject.
>
> This cannot work, because cursor can be built on few tables.
>
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>