Associating the New Array with the Array Column
From InterBase
Go Up to Writing Data to an Array
Execute the UPDATE statement to associate the new array with the array column in the row selected by the statement:
isc_dsql_execute_immediate(status_vector, &db_handle, &trans,
0, /* indicates string to execute is null-terminated */
upd_str, /* UPDATE statement string to be executed */
1, /* da_version number */
in_sqlda ); /* XSQLDA supplying parameters to UPDATE statement */
This sets the array column in the row specified in the UPDATE statement to contain the array ID of the new array. The array ID comes from the array_id variable pointed to by the in_sqlda parameter corresponding to the array column.
If the array column in the specified row contains the array ID of a different array before the UPDATE statement is executed, then the column is modified to contain the new array ID, and the array referenced by the previously stored array ID will be deleted during the next garbage collection.