Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Dave Snyder — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.