| Subject | tib_arraygrid and support data type |
|---|---|
| Author | kamen_lai |
| Post date | 2002-07-05T10:10:26Z |
IB6 , dialect 3 , IBO 4.2Hf
Data Type :
Amount_Arr Numeric(9,2)[18]
In TIB_ArrayGrid , Input 1,2,3,4,5
use
select Amount_Arr[1],Amount_Arr[2],Amount_Arr[3],Amount_Arr[4],
Amount_Arr[5] from x
Result ;
0.01 , 0.02 ,0.03 , 0.04 , 0.05
what kind of datatype support in array column.
P.S i can't use Numeric(18,2)[18] for the datatype ,
it wil produce error .
Data Type :
Amount_Arr Numeric(9,2)[18]
In TIB_ArrayGrid , Input 1,2,3,4,5
use
select Amount_Arr[1],Amount_Arr[2],Amount_Arr[3],Amount_Arr[4],
Amount_Arr[5] from x
Result ;
0.01 , 0.02 ,0.03 , 0.04 , 0.05
what kind of datatype support in array column.
P.S i can't use Numeric(18,2)[18] for the datatype ,
it wil produce error .