Dialect do interbase/firebird

Question

N�o estou conseguindo fazer a mudanca de dialeto 1 para 3 no IB/FB. Sei que o comando correto �:
SET SQL DIALECT TO 3
COMMIT

mas n�o gera resultado algum. Uso o IBExpert e tenho que ir sempre nas propriedades do database para mudar na marra.

Se algu�m tiver alguma dica, por favor me ajude.

Valeu galera!!!

Maicongabriel · Answer

[i:1b69dae254]Direto do Help do IB 6 (leia-se FB tambem)...[/i:1b69dae254]

The dialect of the database. The initial dialect of the database is the dialect of the client that creates it. For example, if you are using isql, either start it with the -sql_dialect n switch or issue the SET SQL DIALECT n command before issuing the CREATE DATABASE command. Typically, you would create all databases in dialect 3. Dialect 1 exists to ease the migration of legacy databases. CREATE DATABASE Note To change the dialect of a database, use gfix or the Properties dialog in IBConsole. See the Migration chapter in Getting Started for information about migrating databases.

Ent�o um exemplo para setar o Dialeto::
[b:1b69dae254]gfix -user SYSDBA -password masterkey banco.fdb -sql_dialect 3[/b:1b69dae254]

F�rum Dialect do interbase/firebird #44376