Subject | PutArray-Error of TIB_ColumnArray in prepared statements |
---|---|
Author | leonhard.schneider |
Post date | 2008-09-11T15:00:41Z |
Hello
Why does my usage of the PutArray method (TIB_ColumnArray of TIB_DSQL)
results to ISC ERROR CODE:335544727, Error writing data to the
connection?
(I use a PREPARED statement WITH PARAMS to insert records to db.)
What to 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 few added/changed 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,
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
LS.
__________________________
[Non-text portions of this message have been removed]
Why does my usage of the PutArray method (TIB_ColumnArray of TIB_DSQL)
results to ISC ERROR CODE:335544727, Error writing data to the
connection?
(I use a PREPARED statement WITH PARAMS to insert records to db.)
What to 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 few added/changed 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,
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
LS.
__________________________
[Non-text portions of this message have been removed]