--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 12:42 PM 1/08/2005 +0000, you wrote:
> >I have a problem with this query:
> >"SELECT KOD_ZONES FROM ZONES ORDER BY KOD_ZONES NULLS FIRST"
> >
> >On that query I get following error message:
> >"Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char
> >48 NULLS"
> >
> >I think that version of FirebirdSS-1.5.2.4731-0 (from rpm package)
> >should contain "order by nulls".
>
> How could you order by nulls, exactly?
>
> Your statement above is perfectly valid syntax for a Dialect 3
> database. It won't work on a Dialect 1 database.
>
> ./heLen

I'm sorry.

I checked dialect again and found that dialect is correct -3, but I
found I use isql version 1.5 but server is running 1.0.3 (that is the
reason why it did not work). Thanks again. It was my fault.