Re: QUES: How to get count using OnLine ESQL/C

Quoting Michel Behna... } } In article <gbar-0104950114380001@gbar.pr.mcs.net> gbar@mcs.com (Robert L. Hays) writes: } >From: gbar@mcs.com (Robert L. Hays) } >Subject: QUES: How to get count using OnLine ESQL/C } >Date: 31 Mar 1995 19:17:12 GMT } } >How can I get the count of records returned after opening the database but } >before fetching the records? } } >I'm using OnLine 5.01 and ESQL/C. } } >Thanks and have fun! - Bob } } You can use either select count(*) or access the systables and get the # of } rows for te table in which you are interested. } Keep in mind that systables.nrows is static, NOT dynamic! The value is updated when you run UPDATE STATISTICS or if you access Info from the isql/dbaccess Table menu. DAS -- Dave Snyder @ Bell Atlantic - Philadelphia, PA WEB: http://www.ece.vill.edu/~dave/index.html EMAIL: (w) ddx85qr@boots.bell-atl.com (h) dave@das13.snide.com