Updated: 2018-01-18

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. Allowed empty value or one value from following list:

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.

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, 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.

Other properties of group

Other sets of properties