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

Posted in 1995

Jack Parker — 4 Apr 1995 13:33:05 -0400 — 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. One of the applications I've run across formats the query statement and then opens two cursors, the first to get a count(*) the second to do the actual work. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, BSMC Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ "I wave my private parts at your aunties. I burst my pimples at you, you tiny empty headed wiper of other peoples bottoms." -MP&THG- French Taunter II _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________