Helmut,

this is a old known problem, very easy to reproduce:

CREATE TABLE TAB1 (
INTCOL INTEGER,
SMINTCOL SMALLINT,
TEXTCOL VARCHAR(20) )

CREATE TABLE TAB2 (
INTCOL INTEGER,
TEXTCOL VARCHAR(20) )

insert into tab1 (intcol,smintcol,textcol)
select :intcol, :smintcol, textcol
from tab2
where textcol = :textcol;

Result with OldParameterOrdering=1 :

intcol --> vartext(20)
textcol --> integer
smintcol --> smallint

Result with OldParameterOrdering=0 and
restarting the server :

intcol --> integer
textcol --> smallint
smintcol --> vartext(20)


IBO 4.2.If TEST,
Firebird 1.5 Release Candidate 5

There has been a interesting thread on this subject "OldParameterOrdering",
startet by Aage Johansen in 14.8.2003. If you dont have a archive, I could
send this thread to you.

Cheers,
Harald