Thanks Woody,
Sadly it's nothing so simple, adding an ORDER BY cause doesn't change
anything, also the Max(TEST_NO) is only about 1048.

On Wed, 2011-05-04 at 12:53 -0500, Woody wrote:
>
> From: "t_wright_1973" <tom@...>
> > Hi,
> > Using firebird server running on a linux server, not sure what
> version but
> > <2.1.
> > The client is iSQL using unix ODBC.
> >
> > Can anyone explain what is happening to TEST_NO in the two
> statements
> > below?
> >
>
> If I had to guess, I'd say that FIRST means nothing without an ORDER
> BY
> clause. Results are more or less random at that point and you could
> get
> anything, mostly by record order in the database, but not for certain.
>
> Woody (TMW)
>
>
>
>
>



[Non-text portions of this message have been removed]