Thanks for your reply. We are using IB Expert as our admin tool. The
query mentioned below works 100% on my computer. It does however not
work on my colleague's computer. We cannot figure out what the
difference is between the 2 setups. We are both using firebird
version 1.5.0.4027 (get that version number from Firebird Server
Manager in the control panel). We are also using the same version of
IB Expert. The error we get on the second computer is:

An error was found in the application program input parameters for
the SQL statement.
Dynamic SQL Error.
SQL error code = -804.
Function unknown.
FIRST.

Alfred, dankie vir die afrikaans, hoe het jy geweet?

Thanks, Adele

--- In firebird-support@yahoogroups.com, "Alfred Thomas"
<alfred@f...> wrote:

> Hi Adel
>
> FireBird 1.5 se select het 'n "select [FIRST N] * from Table"

clause. Dit

> staan ook in die release notes vir verdere reference.
>
> Alfred
>
>
>
> -----Original Message-----
> From: adele_leroux [mailto:adele.leroux@k...]
> Sent: 26 April 2004 03:50
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Select Top n ???
>
>
> Hi All, How would one select the first 50 rows in a table? I
> understand the MS-SQL and MS-Access equivalent is Select Top x ...
> Is this in any way possible with FB and Delphi 7?
>
>
>
>
>
> Yahoo! Groups Links