Firebird Documentation IndexFirebird ODBC/JDBC Driver ManualDeveloping with the Firebird ODBC/JDBC Driver → ARRAY Data Type
Firebird Home Firebird Home Prev: Stored ProceduresFirebird Documentation IndexUp: Developing with the Firebird ODBC/JDBC DriverNext: Usage with Clarion

ARRAY Data Type

To modify single dimension array data type fields, you need to conform to the following rules:

TRAPS!

If you edit an element of the array e.g. element 1, 2 and 5, and do not specify the other elements of the array, e.g. 3 and 4, then the other elements of the array will be zeroed (integer), or blank (string).

With some programs where columns are dependent on array data, it is possible to enter array data into a currently NULL array column without a validity check being made on the various array elements. Under these circumstances it is essential to enter the array elements before entering the column data.

Figure 5.1. Data loss when updating an ARRAY field (1)

Data loss when updating an ARRAY field (1)


Figure 5.2. Data loss when updating an ARRAY field (2)

Data loss when updating an ARRAY field (2)


Prev: Stored ProceduresFirebird Documentation IndexUp: Developing with the Firebird ODBC/JDBC DriverNext: Usage with Clarion
Firebird Documentation IndexFirebird ODBC/JDBC Driver ManualDeveloping with the Firebird ODBC/JDBC Driver → ARRAY Data Type