Hi, IBO-experts,

we have a problem with IBO when using columnarrays
with params in TIB_DSQL:

The method PutArray of TIB_ColumnArray work fine
with params in TIB_Query.
But this results in error when I'm using the same
in TIB_DSQL. Why?
What can I do?

Many thanks for help! Leo Schneider.

Platform: IBO 4.8.7,
Firebird 2.0 (WI-V2.0.1.12855 Firebird 2.0),
Delphi5 on WindowsXP.

////////////////////////////////////////////////////////////////
Details of used code and error:
//
// Code is from original IBO4.8.7-samples, project BlobInserts,
// with following changed or added Lines:
//
// (added in Script: ... INTEGERARR INTEGER [10] ,...)
// (added in dsql.SQL: ... :INTEGERARR, ...)
//
procedure btn_TestItClick:
...
const COUNT_Array=10;
var ArrayIntegers: array[1..COUNT_Array] of Integer;
ArraySize: ISC_LONG;
ii: Integer;
tmpColArr: TIB_ColumnArray;
...
begin
...
for ii:=1 to COUNT_Array do ArrayIntegers[ii]:=ii;
ArraySize:=ISC_LONG(COUNT_Array*4);
tmpColArr:=ParamByName('INTEGERARR') as TIB_ColumnArray;
tmpColArr.PutArray( @ArrayIntegers, @ArraySize );
(* !!! Here the PutArray method results to Error:
The Message is:
ISC ERROR CODE:335544727
ISC ERROR MESSAGE:
Error writing data to the connection.
*)
...
end;
////////////////////////////////////////////////////////////////

My complete source of a test is uploaded to this Yahoo-Group to:
->Files->Bug Testing Applications
->source__TIB_ColumnArray_in_TIB_DSQL-Params.zip
(source to problem: TIB_ColumnArray in TIB_DSQL-Params)
and contains the essentiel test files.

(More details in previous message (Nr. 42814 from Apr 2, 2008,
"Problems with: TIB_ColumnArray in TIB_DSQL-Params".)

LS.