Peter Gore

Project Manager IT

(ddi) 01277 376433

(swb) 01277 372916

(mob) 07952 695755

________________________________

From: Louis Werth [mailto:louis@...]
Sent: 14 July 2004 16:35
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] FIRST SKIP syntax



This Should do it



Select first 10 (select count(*) from myTable) as TOTALROWCOUNT, field1,
field2
From myTable
Where field3 = 'ZZZ'



Peter Gore


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






Yahoo! Groups Sponsor

ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129dce3s9/M=295196.4901138.6071305.3001176/
D=groups/S=1705115386:HM/EXP=1089905885/A=2128215/R=0/SIG=10se96mf6/*htt
p:/companion.yahoo.com>


<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=175757872>



________________________________

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe

>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



__________________________________________________________________________
TM Retail, Ashwells Road, Brentwood, Essex CM15 9ST

This e-mail including any attachments is intended only for the addressee
named above and it may contain confidential or privileged information.
If you are not the intended recipient please notify the sender and note
that the contents must not be disclosed to anyone else, no copies can be
taken and all existing copies must be destroyed.
TM Retail will not be liable for any error in transmission.
You should carry out your own virus checks before opening any attachments.
Opinions, conclusions and other information in this message
and attachments that do not relate to the official business
of TM Retail are neither given nor endorsed by it.
TM Retail is the trading name of Forbuoys Limited.

[Non-text portions of this message have been removed]