Hi,

can anyone give me an example using IBStatement.ExecuteImmediate
with input parameters ?

in_sqlda := AllocMem( XSQLDA_LENGTH( 1 ));
in_sqlda.version := SQLDA_VERSION1;
in_sqlda.sqln := 1;

val := 'Blah';
in_sqlda.sqlvar[0].sqldata := PChar(Val);
in_sqlda.sqlvar[0].sqltype := SQL_TEXT;
in_sqlda.sqlvar[0].sqllen := Length(val);

dsql.ExecuteImmediate('INSERT INTO FILE_BENCHMARK_TAB (TEST) VALUES ( ? )',
in_sqlda);

does not work ( invalid type or number of parameters)

thanks,
maik

-------------------------------------------------
Maik Wojcieszak

wobe-team (http://www.wobe-team.com)