[V4MD 2] gCursor.RecID

[Ruslan Zasukhin]

On 4/8/05 12:02 PM, "info at vallemediatime.com" <info at vallemediatime.com>
wrote:

> I use a simple SELECT in SQL way,
> 
> but now, with this code I am finally successful to obtain the record's RecID
> string ,
> but... how can you see the line code are increased  :-(
> not good...
> 
> repeat with i = 1 to max
> currRec = value(member("dRecPos").text)
> fieldsValue = gCursor.getRecord(currRec)
> ID_Student = getAt(fieldsValue, 1)
> myStudent = string(ID_Studente) && member("sF2").text && member("sF3").text
> myList.append(myStudent)
> gS_Manager.mMoveNext()
> end repeat
> 
> if  I had  <gCursor.RecID> the same code can become:
> 
> repeat with i = 1 to max
> currRec = value(member("dRecPos").text)
> myStudent = string(gCursor.RecID) && member("sF2").text &&
> member("sF3").text
> myList.append(myStudent)
> gS_Manager.mMoveNext()
> end repeat
> 
> Other way... in SQL?

No other way.

We cannot use gCursor.RecID, because how it works then in case you have join
of 2 - 3 tables ?

Only way to SELECT the RecId.

You can select it in any order and even several times.


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