API seach and sort

[info at vallemediatime.com]

Hi Ruslan,
----- Original Message -----
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>
Sent: Thursday, June 23, 2005 9:11 PM
Subject: Re: API seach and sort


> On 6/23/05 6:57 PM, "info at vallemediatime.com" <info at vallemediatime.com>
> wrote:
>
> Hi Paolo.
>
> > Hi Ruslan,
> > I want find a born year of my Students and I want show a sort result
table,
> > in SQL is easy, but in API is more difficult... for me.
>
>
> > This is my attempt:
> >
> > table = gDb.table(gTableName)
> > setAll = table.selectAllRecords()
>     no need!
>
> > rs = table.field("F8").findValue(searchString)
> > sortedSet = table.sort( setAll, rs.field("F8"), #kAsc )
> > showResultGrid(rs, table)
>
> Should be as
>
> table = gDb.table(gTableName)
>
>     rs = table.field("F8").findValue(searchString)  -- this is SET
>     sortedSet = table.sort( rs, table.field("F8") )
>
> showResultGrid(rs, table)

I've tried but don't works.
I get a Director script error: "Object expected"
the object is into a miaw and this is more difficult to debug.

With simple:
rs = table.field("sF8").findValue(searchString)
showResultGrid(rs, table)

I don't get error, strange!

> Btw, in fc9 Igor have add
>     VTable.GetRecord() function.
Are you sure? in the Mantis seems only assigned but not resolve.
If  it'is resolved can you send me the code for try it?
The new function is not documented I think.
Thanks Paolo

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