Hi All,

A quick question on setting SQL Dialects.

We are migrating Interbase 5.6 database to Firebird 1.5.4. We have
used register exisiting database option in Flamerobin to register
the existing Interbase database on Firebird. The SQL Dialect is 1
now in Firebird database.

We would like to change the SQL Dialect to 3 at the database level.

But the command SET SQL DIALECT 3; is used to set Dialect at the
connection level.

Any commands for setting Dialect at database level?

We tried using the gfix command, but getting the attached error.

Can anybody give your thoughts on how to achieve this (Setting SQL
Dialect to 3)?

Thanks,

Murali.