| Subject | Re: [ib-support] Record Count | 
|---|---|
| Author | Woody | 
| Post date | 2001-11-07T21:39:49Z | 
From: "Mike Grover" <mike@...>
everything from the "FROM" clause and adds it to the end of a "Select
Count(*) " string. Then, I execute this query and return the count. It works
for most query situations but can get complex depending on what you need
specifically.
Woody
            > This is a read only database.I built a generic count procedure for simple queries that just strips
> The user needs to see a record count and some of the fields from a query.
>
everything from the "FROM" clause and adds it to the end of a "Select
Count(*) " string. Then, I execute this query and return the count. It works
for most query situations but can get complex depending on what you need
specifically.
Woody