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: 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.









view thread (4+ messages)  latest in thread

Message-ID: <s05ecef2.084@pcux.citec.qld.gov.au>
Permalink:  ../s05ecef2.084@pcux.citec.qld.gov.au/

 · 


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