Thx...

This works fine....

as I said in the subject - Simple SQL, but I think my brain is acting
a little slow these days. I think I need some vacation.

Mihcael

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:

>
> Hi,
>
> > I have a rutine in which I would like to have a progressbar.
>
> You mean, a progress bar that counts up while running this
> query? Or a progress bar that proceeds while handling the
> resultset of this query?
>
> > The SQL is like this:
> >
> > Select
> > Field1,
> > Field2,
> > SUM(Field3)
> > from Table1
> > Group by 1,2
> >
> > I would like to be able to count how many records there will be
> > returned to me by this SQL.
> >
> > Can I do that ?
>
> You would have to run it twice, I think.
>
> select count(*) from (Select
> Field1,
> Field2,
> SUM(Field3)
> from Table1
> Group by 1,2)
>
> Martijn Tonies
> Database Workbench - development tool for Firebird and more!
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>