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

Posted in 1995

Michel Behna — Mon, 3 Apr 1995 12:45:22 — source: Informix-list mailing list archive (1991-1998)

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.