From: Steven Clements Subject: RE:ABF programming Date: 1995/09/19 Message-ID: X-Original-Message-ID: #1/1 X-Deja-AN: 110331475 sender: daemon@solitaire.cv.nrao.edu organization: National Radio Astronomy Observatory newsgroups: comp.databases.ingres ** 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 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.