Is there MaxRecords option in ODAC?

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ivsal
Posts: 4
Joined: Sat 11 Jun 2005 13:43

Is there MaxRecords option in ODAC?

Post by ivsal » Sat 11 Jun 2005 13:53

I want to fetch only first n records from a Query.
I can use such a query:
SELECT * FROM (

)
WHERE ROWNUM <= n,
but there are some limitations.
So is there MaxRecords option in ODAC?
Something like MaxRecords property in ADO.

Alex
Posts: 655
Joined: Mon 08 Nov 2004 08:39

Post by Alex » Mon 13 Jun 2005 06:23

There is no such functionality in ODAC, but you can see http://crlab.com/forums/viewtopic.php?p=1301#1301 topic it may be intresting for you.

Post Reply