dam_getUpdateRow

This function gets the row of data to be used for updating the selected rows in the database. The processing for UPDATE is as for SELECT, up to the point of finding the row in the data source that matches the conditions in the query. At this point, update processing requires the update values specified in the query to be used to modify the selected row in the data source.

Use the functions dam_getFirstValueSet and dam_getNextValueSet to step through the columns of the update row. Use the functions dam_getColToSet and dam_getValueToSet to retrieve the corresponding column handle and the associated value.

The function dam_describeCol can be used with the column handle to retrieve the name and number of the target column. dam_getUpdateRow should be called after dam_isTargetRow returns true, to get update values based on the selected row, in case the update values are derived from expressions.

Table 158. Parameters for dam_getUpdateRow
Parameter	Type	Description
IN
hstmt	DAM_HSTMT	The statement handle of the current statement.
hTargetRow	DAM_HROW	The handle of the row for which the update operation is applied. This would be a row that passes the dam_isTargetRow call.
RETURN
	DAM_HROW	The handle to the update row. NULL is returned if an update row is not available. This handle is required by dam_getFirstValueSet. Do not call dam_freeRow on this handle to free this row. It is automatically freed by the OpenAccess SDK SQL engine.

dam_getUpdateRow

See also