V4MD help for sort a rs into a table

[Ruslan Zasukhin]

On 9/8/05 1:56 PM, "info at vallemediatime.com" <info at vallemediatime.com>
wrote:

> Hi Ruslan,
> i need your help for work with this API "find and sort" script that get me
> always the sortedSet of gTable and not the sortedSet of rs. Where I made
> mistake?
> Thanks
> Paolo
> 
> on sortByColAZ
> gTable = gDB.Table(gTableName)
> rs = gTable.selectAllRecords()
> rs = gTable.field("angF30").findValue("1", rs)
> clickedCol = gFieldPrefix & "F" & member("dColNum").text
> if member("dColNum").text <> "0" then
> sortedSet = gTable.sort( rs, gTable.field(clickedCol), #kAsc )
> tableData = ProduceTableData(#201, sortedSet, gTable)
> end if
> end

I see overhead calls in the first lines. No need do SelectAll()


on sortByColAZ
 
    gTable = gDB.Table(gTableName)

    rs = gTable.field("angF30").findValue("1")

    clickedCol = gFieldPrefix & "F" & member("dColNum").text

    if member("dColNum").text <> "0" then
        sortedSet = gTable.sort( rs, gTable.field(clickedCol), #kAsc )
        tableData = ProduceTableData(#201, sortedSet, gTable)
    end if

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]