getting recid in sql stmt but then in cursor has problem

[Ruslan Zasukhin]

on 1/24/04 5:11 AM, Dave Parizek at dave at Parizek.com wrote:

> I understand you need to specify if you want the recid in a sql select stmt:
> 
> select Solditem.RecId, * from Solditem
> 
> and then this works correctly:
> 
> w.lb.Cell(w.lb.LastIndex, w.RecIDCol) = mCursor.Field("RecID").GetString
> 
> 
> 
> But if I use full field name it does NOT work, returns nil object in V4RB:
> 
> w.lb.Cell(w.lb.LastIndex, w.RecIDCol) =
> mCursor.Field("Solditem.RecID").GetString
                ^^^^^^^^^^^
            Dave, in this place full name NEVER did work.


> So what do you do if you create a cursor that includes RecID's from 2
> or more different tables, and you need to access those RecID's, how
> do you differentiate between them?

By INDEX

        GetField(1)

        GetField(2)


> The RecID I am getting in first example above is for the base object,
> right, not the cursor?  If it is for the cursor or something, then
> how do I get the RecID for the record of the base object?

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