FETCH ROWS IN FIREBIRD 2.0

  • Thread starter Thread starter juancho8529
  • Start date Start date
J

juancho8529

I ned know how set the number of rows obtained from a interbase 2.0
query, hi have tried with instructions has fetch rows, limit, top...
but i didn't have found a correct result,
Please if somebody can help me!

(for example... i need get the rows to 5 to 10 from the sql sentence
select field1,field2 from my table)
 
Hello!
I ned know how set the number of rows obtained from a interbase 2.0 query.
Click to expand...

I'm not sure about FireBird, but with Borland (CodeGear) InterBase since
version 7.0, you can use the ROWS argument in the SELECT statement. For
instance to return rows 5 to 10:

--------
SELECT name, address, city
FROM customers
ORDER BY name
ROWS 5 TO 10
--------

If FireBird supports the same notion, then that is the answer to your
question. Check your FireBird 2.0 SQL Reference documentation for details.

Here's the link to InterBase 6.0 SQL reference, which was the starting point
to FireBird. I didn't seem to find a SQL reference specifically for FireBird
2.0.

http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_60_sqlref

Hope this helps.

--
Regards,

Mr. Jani Järvinen
C# MVP
Helsinki, Finland
(e-mail address removed)
http://www.saunalahti.fi/janij/
 
Back
Top