On 19-4-2013 19:09, ramona.grissom wrote:

> The error is
>
> Invalid token.
> Dynamic SQL Error.
> SQL error code = -104.
> Token unknown - line 3, column 1.
> "account number".
>
> I believe they are dialect 1, what is the difficulty in changing the dialect?

Start with the Interbase 6.0 "Getting Started", section "Migrating
databases to dialect 3" (page 39). You can download it from
http://www.firebirdsql.org/en/reference-manuals/

Biggest difference is some keywords, changes with DATE (in dialect 3 it
doesn't contain a time portion, you need TIMESTAMP in dialect 3) and
strings should be quoted with single quotes.

Mark

--
Mark Rotteveel