API: find 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 30, 2005 9:41 AM
Subject: Re: API: find and sort


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

good! with VOID instead NULL on Director :-)
set1 = table.field("sF8").findRange( true, searchString, VOID, false )

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.8.7/34 - Release Date: 29/06/2005
>
>