Thank you very much for your answer Dmitry

Greetings.

Walter.

On Sun, Jun 30, 2013 at 4:27 PM, Dmitry Kuzmenko <kdv@...> wrote:

> **
>
>
> Hello, W!
>
> Monday, July 1, 2013, 12:15:21 AM, you wrote:
>
> WO> Hello
> WO> Somebody knows how to use arrays?
>
> do not use arrays, ever.
> Arrays are stored "inside" blobs, so, it's simpier
> to use blob for your client array data.
> Because the only thing you can do in SQL/DML with arrays is selecting
> array element.
> Insert and update you can do only at client side, writing array as a
> blob. Or, you may use embedded sql preprocessor gpre, but I think
> you will not like that idea :-)
>
> But, if you are just curious, check procedures in employee.fdb and
> InterBase's documentation.
>
> p.s. someone thinks that arrays are better than blobs, because
> they can update only part of array, not the whole array.
> But, this is not true - new array is written the whole, same as
> if you will try to modify 1 byte in 1mb blob - 1 mb will be written.
>
> --
> Dmitry Kuzmenko, www.ib-aid.com
>
>
>


[Non-text portions of this message have been removed]