One language feature I'm absolutely stunned to find missing in IB is the
LIMIT clause which limits the number of rows returned from a query. From
memory MSSQL has two varieties of this (including TOP n), and most other
DMLs seem to have at least one simple way of limiting the result set at the
server end.
IBO has the MaxRows property which provides the same functionality, but it's
not a nice as saying SELECT * from MyTable ORDER BY TheDate LIMIT 20 or
something similar.
Simon.
-----
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
