V4MD fc12: table.GetRecord(i)

[info at vallemediatime.com]

Hi Ruslan, 

----- Original Message ----- 
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina-beta at lists.macserve.net>; "Igor Gomon" <giv at tlc.kherson.ua>
Sent: Friday, July 01, 2005 11:10 AM
Subject: Re: V4MD fc12: table.GetRecord(i)


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

ok, I've understand the problem, and I conferm you that:
table.GetRecord(i)
is more fast in Director for show fields value in grid...
(in my test SQL is still a bit better).
but it is necessary to add a method for get RecID.
I wait for a good idea
Paolo


> 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]
> 
> 
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta
> 
> 
> 
> -- 
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.8.8/35 - Release Date: 30/06/2005
> 
>