Updated: 2024-02-26
Data Source Initialization OLE DB Property – «array_rw_mode»
Name:
array_rw_mode
Type:
VT_BSTR
R/W:
R/W
Default:
EMPTY
IBProvider:
3.28, 5
The read/write mode of database arrays. An empty value or one value from the following list is allowed:
| Value | Description |
| api |
Read/write of database arrays through ISC API. It is default mode for IB7.1, IB7.5, IB8, IB9, IB10, IB11, IB12, IB13+ and for other servers with unknown implementation (platform). |
| direct |
Read/write of database arrays through own (builtin) services of provider. It is default mode for Yaffil, IB4-IB7.0, FB0.9, FB1.0, FB1.5, FB2.0, FB2.1, FB2.5, FB3.0, FB4.0. Also supported for IB7.1, IB7.5, IB8, IB9, IB10, IB11, IB12.0, IB13.0. |
When using the «direct» mode, IBProvider directly works (read/write) with BLOB of array data. This allows to resolve some bugs of server, linked with arrays. For example — the problem with VARYING-arrays.
The «direct» mode is supported only for servers with «known» implemenations and «known» ODS of databases. See below the list of supported servers and platforms.
With explicit definition of «direct» mode and connection to server with unsupported implementation, IBProvider returns the initialization error.
«array_rw_mode» applies to all column with arrays. Configuration of individual columns not supported.
List of server’s platforms, which supported by «direct» mode
| Platform | Servers |
| winnt_x86 | Yaffil, FB0.9, FB1, FB1.5, FB2.0, FB2.1, FB2.5, FB3.0, FB4.0, IB4, IB5, IB6.0, IB6.5, IB7.0, IB8, IB9, IB10, IB11, IB12, IB13. |
| winnt_amd64 | FB2.1, FB2.5, FB3.0, IB10, IB11, IB12, IB13. |