--- In ib-support@y..., "mk_delphi" <mk_delphi@y...> wrote:

> The Dialect is 3,

[skip]

> > NO error messages from Firebird....

Marco, firstly make shure there is only one gds32.dll on client
machine and it's version is the same as server. Than, what is the
client program via which you get this result? Some old tools, WISQL32
for example, forces dialect 1 in API calls regardless of gdb dialect.
If this query is placed within SP/trigger and this SP/trigger was
created/altered via such a tool, it is compiled into dialect 1 BLR,
so in this case you should recompile it using one of modern tools.

Best regards, Alexander V.Nevsky.