API seach and sort

[Ruslan Zasukhin]

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)



-----------------------
Btw, in fc9 Igor have add

    VTable.GetRecord() function.



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