OpenAccess SDK SQL Engine core methods for .NET : Methods for .NET reference : dam_getUpdateRow

dam_getUpdateRow

This method 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 this method with the following related functions:

• Use dam_getFirstValueSet and dam_getNextValueSet to step through the columns of the UPDATE row.

• Use dam_getColToSet and dam_getValueToSet to obtain the corresponding column handle and the associated value.

• Use dam_describeCol method with the column handle to get the name and number of the target column.

The dam_getUpdateRow method 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.

int64 dam_getUpdateRow(

int64 hstmt,

int64 hTargetRow)

Table 183: Parameters for dam_getUpdateRow
Parameter	Type	Description
IN
hstmt	int64	The statement handle of the current statement
hTargetRow	int64	The handle of the row for which the update operation will be applied. This would be a row that passes the dam_isTargetRow call.
RETURN
	int64	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