TOP(n) is only available in SQLServer 7.
> -----Original Message-----
> 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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
