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: > How can I get the count of records returned after opening the database but > before fetching the records? The previous contributions mentioned systables.nrows etc. This will only give an indication/correct count (depending on UPDATE STATISTICS as mentioned) for (e.g.) 'SELECT * FROM table WHERE 1=1' e.g. where all rows are to be read from one table only with no filtering. Was that what you# were interested in? -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================