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

Michel Behna (mbehna@promus.com) wrote: : 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? Opening the database doesn't return any records (sic) so the count will always be 0! :-) : >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. This is potentially misleading in that you give the impression that both methods return the same number. They don't! -- graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.