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

} } 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. A consideration.... - select count(*) is slow, but accurate - The systables column nrows is not correct unless an update statistics was just completed. -- Naomi Walker (aka N7FSA) | naomi@anasazi.com | Phoenix, Arizona ---------------------------------------------------------------------- It's almost impossible to overestimate the unimportance of most things.