Subject | array |
---|---|
Author | Ulrich |
Post date | 2004-04-05T08:28:38Z |
Hello,
in one of my db-tables there are 10 numeric(18,4) fields for storing
ten diferent prices. I thought about to store them in the array :
NUMERIC(18,4) [1:10]
In my app I use an array[10] of currency. To store the array into
database i use the following code :
procedure price_store;
Var ArraySize : ISC_LONG;
ArrayCol : TIB_ColumnArray;
price : Array [1..10] of currency;
begin
// here is some code to read the prices out of a stringgrid
// and store them in price array
ArraySize := ISC_LONG(sizeof(price));
with Ib_QueryArticles.fieldByName('price') as TIB_ColumnArray do
putArray(@price,@ArraySize);
end;
I receive an "ISC 335544329 - invalid blob-id" error message, but
nevertheless the prices will be stored in the datafield.
The TIB_query SQL is a simple "select * from articles" statement. Is
it somehow necesary to inform the TIB_Query about the array datafield?
What can I do to avoid these errror message, and what further
information for me is in this error message?
regards - Ulrich
in one of my db-tables there are 10 numeric(18,4) fields for storing
ten diferent prices. I thought about to store them in the array :
NUMERIC(18,4) [1:10]
In my app I use an array[10] of currency. To store the array into
database i use the following code :
procedure price_store;
Var ArraySize : ISC_LONG;
ArrayCol : TIB_ColumnArray;
price : Array [1..10] of currency;
begin
// here is some code to read the prices out of a stringgrid
// and store them in price array
ArraySize := ISC_LONG(sizeof(price));
with Ib_QueryArticles.fieldByName('price') as TIB_ColumnArray do
putArray(@price,@ArraySize);
end;
I receive an "ISC 335544329 - invalid blob-id" error message, but
nevertheless the prices will be stored in the datafield.
The TIB_query SQL is a simple "select * from articles" statement. Is
it somehow necesary to inform the TIB_Query about the array datafield?
What can I do to avoid these errror message, and what further
information for me is in this error message?
regards - Ulrich