am_update

mi_integer am_update(MI_AM_TABLE_DESC *tableDesc, 
   MI_ROW *row, mi_integer rowid);

tableDesc: points to the table descriptor.
row: points to the row structure that contains the updated values.
rowid: indicates where to write the updated values.

The am_update function modifies the contents of an existing row.

If the access method needs to move the updated row, am_update can take the following actions:

Deletes the old row
Adjusts the data format in row to conform to the source data
Stores the updated source-data record
Stores the updated row identifier

Important:

The database server does not call am_update unless both the am_rowids and am_readwrite purpose flags are set. For more information about setting purpose flags, refer to SQL Statements for Access Methods.

Warning:

If the access method does not supply am_update, but an SQL statement requires it, the database server raises an error. For more information on how to handle this error, refer to Supplying Error Messages and a User Guide.

MI_OK indicates success. MI_ERROR indicates failure.

See the descriptions of:

Purpose functions am_delete and am_insert
Purpose flags am_rowids and am_readwrite in Settings Purpose Functions, Flags, and Values
Inserting, Deleting, and Updating Data

am_update

Syntax

Usage

Return Values

Related Topics