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: Steven Clements <CLEMENS@pcux.citec.qld.gov.au>
Subject: RE:ABF programming
Date: 1995/09/19
Message-ID: <s05ecef2.084@pcux.citec.qld.gov.au> (raw)
** 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.
------------------------------------------------------------------------------
Steve Clements If you can
find an opinion here its
About Time Software Solutions yours to
keep.
Brisbane, Queensland, Australia
Member at Large, Queensland IUA Email:
clemens@pcux.citec.qld.gov.au
ph & fax: 61-7-217-2118 or
sclement@interconnect.com.au
------------------------------------------------------------------------------
>>> 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));
------------------------------------------------------------------------------
-MV (Maarten Veerman) Platon Consulting
Limited, New Westminster, B.C. emvy@platon.com
AIX-UNIX, Ingres, & Forest Industry
Applications
------------------------------------------------------------------------------
These opinions are mine, & mine alone.
Even if you wanted to, you couldn't have them.