<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2604" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=638524022-11042005><FONT face=Arial
color=#0000ff size=2>This is a cut from my code:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=638524022-11042005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=638524022-11042005><FONT size=2>
<P>+ " from ForumPosting fp, ForumThread fth"</P>
<P>+</P>
<P>" where fp.forum_id = ? and fp.id = fth.id" +</P>
<P>" order by fth.threadsticky desc, fth.threadlastpost desc"+</P>
<P>" rows ? to ?";</P></FONT></SPAN></DIV>
<DIV><SPAN class=638524022-11042005><FONT face=Arial color=#0000ff size=2>What
are you developing against?</FONT></SPAN></DIV>
<DIV align=left><FONT face=Arial size=2>---</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Richard Vowles</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Borland Solutions Architect</FONT></DIV>
<DIV align=left> </DIV>
<DIV align=left><FONT face=Arial size=2>phone: +64-9-9184573</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>mobile: +64-21-467747</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>email: <A
href="mailto:richard.vowles@borland.com">richard.vowles@borland.com</A></FONT></DIV>
<DIV align=left><FONT face=Arial size=2>im:
msn: <A href="mailto:richard.vowles@borland.com">richard.vowles@borland.com</A>,
skype: rvowles</FONT></DIV>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><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></FONT><BR></DIV>
<DIV></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></BODY></HTML>