| Subject | Re: [firebird-support] How update a field array ? |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-12-15T23:59:28Z |
At 07:17 PM 15/12/2004 -0200, you wrote:
manages internally.
You can't access array members through SQL. You use API calls to get and
put "slices" (plus a few other operations).
Some API interfaces (e.g. IBObjects) have implementations of the
isc_array_* functions.
./hb
>I have the field: qtd_day numeric(15,3)[1:365]The array implementation is a streamed blob that the server maps and
>
>... I try update like: update table set qtd_day[1] = 123, qtd_day[100] =
>456 where blablabla.
>
>... but I receive a error ....
>
>What is wrong ?
manages internally.
You can't access array members through SQL. You use API calls to get and
put "slices" (plus a few other operations).
Some API interfaces (e.g. IBObjects) have implementations of the
isc_array_* functions.
./hb