pg.ddx.io  University INGRES on Usenet (1985-1995): threads about Berkeley INGRES, QUEL and EQUEL from comp.databases.ingres, comp.databases and net.database  
help / color / mirror / Atom feed
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
--------------------------------------------------------------------------






view thread (4+ messages)  latest in thread

Message-ID: <30A75F13.2BB7@denitqm.mnet.uswest.com>
Permalink:  ../30A75F13.2BB7@denitqm.mnet.uswest.com/

 · 


This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox