pg.ddx.ioUniversity INGRES on Usenet (1985-1995): threads about Berkeley INGRES, QUEL and EQUEL from comp.databases.ingres, comp.databases and net.database
From: Jerry Bull <gbbull@denitqm.mnet.uswest.com>
Subject: Re: ABF programming
Date: 1995/11/13
Message-ID: <30A75F13.2BB7@denitqm.mnet.uswest.com> (raw)
References: <s05ecef2.084@pcux.citec.qld.gov.au>
Steven Clements wrote:
>
> ** Low Priority **
>
> INQUIRE_FORMS table '' ( your_varname = rowno (
> your_tblname));
>
> Will give you the row number within the rows being
> displayed on the screen BUT will not give you the
> row number within the dataset.
>
> ie. If I have 5 rows showing on the screen but 10
> rows in my data set I could be showing the 7th row
> from the dataset on the 3rd line of the screen.
> Then the above command would return the value 3.
>
> You have to perform an UNLOADTABLE loop and match
> your current data against each row until you match
> the actual data row in the dataset to determine
> the row number within the dataset.
> >>> MV-Maarten Veerman <emvy@platon.com>
> 16/September/1995 09:20am >>>
> In article <43c8om$oao@midgard.calvacom.fr>,
> cxp10@calvanet.calvacom.fr says...
> >
> >How can I get the current row number in a table
> field to get back on
> >when I leave the frame ?
>
> INQUIRE_FORMS table '' ( your_varname = rowno (
> your_tblname));
You can also use the table._record attribute outside of the
UNLOADTABLE.
Jerry.
--------------------------------------------------------------------------
Jerry Bull, MTS voice: (303) 624-3073
U S WEST Information Technologies fax: (303) 624-8462
931 14th Street, Suite 920 email: gbbull@denitqm.mnet.uswest.com
Denver, CO 80202
--------------------------------------------------------------------------