Subject RE: [firebird-support] FIRST SKIP syntax
Author Louis Werth
Milan, thanks for your response!

Milan Babuskov Wrote :
And where would you like to have that total number of rows? As another
column which always has the same value?

Yes, as a new column. a Nice example would be:

Select first 10, TOTALROWCOUNT, field1, filed2
From myTable
Where field3 = 'ZZZ'

Where TOTALROWCOUNT would be the record count of the result set ignoring the
"FIRST" Statement.

I am trying to achieve the same as a Google web search. Display page 1 of
10. Where each page would have 10 records on it. (Speed and Less Network
Traffic)

Don't you think by implementing your suggestion would slow down the
preparing and executing of such a qry's.

Does anyone know if this functionality will be added in the future, or
correct me if I am asking for the unnecessary.

Regards
Louis Werth