Anybody used IBX for dealing array field?
lazarus / 16-Databases

----------------------------------------------------------------------
egsuh · 2021-09-04 14:18

Firebird supports array-type field, but it is not possible to operate
with SQL. IBX documentation says it supports array-field operation.
Has anybody tried to use this functionality? What does it support, and
how useful it is?
I'm looking for IBX documentation, but it explains the internal
operations, and not easy to find out how to use.

----------------------------------------------------------------------
dsiders · 2021-09-04 18:53

Quote from: egsuh on September 04, 2021, 04:18:22 pmFirebird supports
array-type field, but it is not possible to operate with SQL. IBX
documentation says it supports array-field operation. Has anybody
tried to use this functionality? What does it support, and how useful
it is?
I'm looking for IBX documentation, but it explains the internal
operations, and not easy to find out how to use.


For code, look at the examples/employee demo shipped with IBX.

----------------------------------------------------------------------
tonyw · 2021-09-05 13:49

Quote from: dsiders on September 04, 2021, 08:53:03 pmQuote from:
egsuh on September 04, 2021, 04:18:22 pmFirebird supports array-type
field, but it is not possible to operate with SQL. IBX documentation
says it supports array-field operation. Has anybody tried to use this
functionality? What does it support, and how useful it is?
I'm looking for IBX documentation, but it explains the internal
operations, and not easy to find out how to use.


For code, look at the examples/employee demo shipped with IBX.
Even better, try out the examples/array demos which illustrate both 1D
and 2D array handling