V4MD fc12: table.GetRecord(i)

[Ruslan Zasukhin]

On 7/1/05 11:50 AM, "info at vallemediatime.com" <info at vallemediatime.com>
wrote:

> Hi Ruslan,
> please can you test this?
> I cant't get RecID in API way and show it into my grid.

In SQL this works because you have made query as

    SELECT RecID, * ...

Right ?

In API way, RecId is hidden field, you do not see it on default.
As well as in SQL. You was need ASK for it.
 
Right now Vtable.GetRecord() will not show RecId.
Hmm, it needs to think how to do this...

A) parameter requst
B) return it always, but then OID field also.

> In SQL this works:
> 
> SQL
> --on updateGrid n
> -- sprite(n).SetRow(0, string(gHeaderList))
> -- recCount = value(member("recCount").text)
> -- sprite(n).rowCount = RecCount +1
> -- sprite(n).colCount = gHeaderList.count
> 
> -- repeat with i = 1 to RecCount
> -- fields = gCursor.getRecord(i)
> -- sprite(n).SetRow(i,string(fields))
> -- end repeat
> --end 
> 
> API (same code of SQL except row "X")
> 
> --on ProduceTableData (n, rs, table)
> -- sprite(n).SetRow(0, string(gHeaderList))
> -- recCount = rs.itemCount
> -- sprite(n).rowCount = RecCount +1
> -- sprite(n).colCount = gHeaderList.count
> 
> -- repeat with i = 1 to RecCount
> X-- fields = table.GetRecord(i)
> -- sprite(n).SetRow(i,string(fields))
> -- end repeat
> --end

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