API: find and sort

[Ruslan Zasukhin]

On 6/30/05 9:48 AM, "info at vallemediatime.com" <info at vallemediatime.com>
wrote:

Hi Paolo,

> Hi Ruslan,
> I'm trying the last update fc12, it's seems more fast of previous and now many
> V4MD bugs are fixed, very good. :-)
> 
> Now I want to finish this search:
> 
> table = gDb.table(gTableName)
> set1 = table.field("sF8").findValue(searchString)
> rs = table.sort( set1, table.field("sF8"))
> showResultGrid(rs, table)
> 
> sF8 contains the born year of Students and I want to find all Students born
> from (n year = searchString) and not only in one year,
> in SQL this works:
> query = "SELECT RecID, * from STUDENTI WHERE sF8 >= '" & searchString & "'
> ORDER BY sF8"
> 
> but how can I do this in API  (if it's possible)?

You need to use not FindValue, but FindRange

Using mathematical range  [10, +inField )

    set1 = table.field("sF8").findRange( true, searchString, NULL, false )


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