<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2900.2604" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV><!--StartFragment --><SPAN class=677463622-11042005><FONT face=Arial
color=#0000ff size=2>IB 6.5 </FONT></SPAN></DIV>
<DIV><SPAN class=677463622-11042005><FONT face=Arial color=#0000ff size=2>from
</FONT></SPAN><FONT face=Arial color=#0000ff size=2><A
href="http://www.dbginc.com/tech_pprs/IB65New.html">http://www.dbginc.com/tech_pprs/IB65New.html</A></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV>SELECT * FROM SALES<BR>ORDER BY DISCOUNT DESC<BR>ROWS 1 TO 5 </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=677463622-11042005><FONT face=Arial color=#0000ff size=2>FB :
</FONT></SPAN></DIV>
<DIV><SPAN class=677463622-11042005><FONT face=Arial color=#0000ff size=2>from
<A
href="http://www.experts-exchange.com/Databases/Interbase/Q_20802714.html">http://www.experts-exchange.com/Databases/Interbase/Q_20802714.html</A></FONT></SPAN></DIV>
<DIV><!--StartFragment --> SELECT [FIRST(10)] [SKIP(2)] <rows> FROM
.... </DIV><!-- Converted from text/plain format --><FONT face=Arial
color=#0000ff size=2></FONT><BR><BR><SPAN class=677463622-11042005></SPAN><FONT
face=Arial><FONT color=#0000ff><FONT size=2>Cheers, Kurt.<SPAN
class=677463622-11042005></SPAN></FONT></FONT></FONT><BR>
<P><FONT size=2>--<BR><BR> </FONT> </P>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
delphi-bounces@ns3.123.co.nz [mailto:delphi-bounces@ns3.123.co.nz] <B>On
Behalf Of </B>Phil Middlemiss<BR><B>Sent:</B> Tuesday, 12 April 2005 8:39
a.m.<BR><B>To:</B> NZ Borland Developers Group - Delphi
List<BR><B>Subject:</B> Re: [DUG] Getting number of records in an Interbase
Table<BR><BR></FONT></DIV>Hmmm, I tried that query using EMS
Interbase/Firebird Manager and it didn't like the ROWS keyword (didn't even
highlight it as a keyword).<BR><BR>Richard Vowles wrote:
<BLOCKQUOTE
cite=mid5D4E2BDFF82ABB47ACC2E4E57A94DD27102933@ausys-mail01.apac.borl.net
type="cite"><PRE wrap="">Have we missed out why you can't just use the ROWS keyword in the SELECT statement? This is InterBase right? Firebird 1.5 is slightly different.
SELECT * FROM TABLE ROWS 15 TO 25
or something like that. I use it for paging through forums.
Richard
</PRE><PRE wrap=""><HR width="90%" SIZE=4>
_______________________________________________
Delphi mailing list
<A class=moz-txt-link-abbreviated href="mailto:Delphi@ns3.123.co.nz">Delphi@ns3.123.co.nz</A>
<A class=moz-txt-link-freetext href="http://ns3.123.co.nz/mailman/listinfo/delphi">http://ns3.123.co.nz/mailman/listinfo/delphi</A>
</PRE></BLOCKQUOTE></BLOCKQUOTE><div><p><font size="1">
This electronic message together with any attachments is confidential and
intended for the named recipient's use only. If you are not the intended
recipient (i) do not copy, disclose or use the contents in any way, (ii)
please let us know by return email immediately then destroy the message, and
any hard copies of the message, and any attachments. The sender of this
message is not responsible for any changes made to this message and/or any
attachments and/or connection linkages to the Internet referred to in this
message after it has been sent. Unless otherwise stated, any pricing
information given in this message and/or attachments is indicative only, is
subject to change and does not constitute an offer to buy or sell securities
or derivatives at any price quoted. Any reference to the terms of executed
transactions should be treated as preliminary only and subject to separate
formal written notification. Where reference is made to research material
and/or research recommendations, the basis of the provision of such research
material and/or recommendations is set out in the relevant disclaimer.
</font></p></div>
</BODY></HTML>