Subject RE: [ib-support] Record Count
Author Mike Grover
Can I look at this?

-----Original Message-----
From: Woody [mailto:woody.tmw@...]
Sent: Wednesday, November 07, 2001 3:40 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Record Count


From: "Mike Grover" <mike@...>
> This is a read only database.
> The user needs to see a record count and some of the fields from a query.
>

I built a generic count procedure for simple queries that just strips
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


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Universal Inkjet Refill Kit $29.95
Refill any ink cartridge for less!
Includes black and color ink.
http://us.click.yahoo.com/bAmslD/MkNDAA/ySSFAA/dpFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/