Hi, Jason, hi, IBO-experts,

may I apply PutArray() to TIB_ColumnArray-Params
in PREPARED SQL-statements ("INSERT ...")?
If I try it, that results in error message:

ISC ERROR CODE:335544727
ISC ERROR MESSAGE:
Error writing data to the connection.

What's wrong? What can I do?
Many thanks for help! Leo Schneider.



(Jason, you remember you wanted to check my code:

> ...
> I'll download your sample app and have a look
> at it and see what I can do.

Thanks, Leo Schneider.)


////////////////////////////////////////////////////////////////
//Extraction of used code and error:
//
// Code is derived 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;
////////////////////////////////////////////////////////////////


Complete source of my 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).

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


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