<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
I'm developing against the latest Firebird. The SKIP and FIRST work
nicely - although too late now to use since I've finished the bit I was
working on.<br>
<br>
Phil.<br>
<br>
Richard Vowles wrote:
<blockquote
cite="mid5D4E2BDFF82ABB47ACC2E4E57A94DD275FF428@ausys-mail01.apac.borl.net"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta content="MSHTML 6.00.2900.2604" name="GENERATOR">
<div align="left" dir="ltr"><span class="638524022-11042005"><font
color="#0000ff" face="Arial" size="2">This is a cut from my code:</font></span></div>
<div align="left" dir="ltr"><span class="638524022-11042005"></span> </div>
<div align="left" dir="ltr"><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 color="#0000ff"
face="Arial" 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" align="left" dir="ltr" lang="en-us">
<hr tabindex="-1"><font face="Tahoma" size="2"><b>From:</b>
<a class="moz-txt-link-abbreviated" href="mailto:delphi-bounces@ns3.123.co.nz">delphi-bounces@ns3.123.co.nz</a> [<a class="moz-txt-link-freetext" href="mailto:delphi-bounces@ns3.123.co.nz">mailto:delphi-bounces@ns3.123.co.nz</a>] <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>
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 size="4" width="90%">
_______________________________________________
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>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
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>