'Declaration Public Event AfterUpdateRow As RowUpdateEventHandler
public event RowUpdateEventHandler AfterUpdateRow
Event Data
The event handler receives an argument of type RowUpdateEventArgs containing data related to this event. The following RowUpdateEventArgs properties provide information specific to this event.
| Property | Description |
|---|---|
| DeleteCommand | For a deleted row, the object representing the SQL DELETE command used to delete the row from the database. |
| Error | For an unsuccessful operation, information detailing the error. |
| InsertCommand | For an added row, the object representing the SQL INSERT command used to add the row to the database. |
| Row | The row that is committed to the database. |
| SelectCommand | For a modified and added row, the object representing the SQL SELELCT command used to refresh the row with database values after the row has been committed to the database. |
| SqlStatus | Success or failure status of the database access operation. For an unsuccessful operation, specifies the cause of failure. |
| Status | Success or failure status of the operation. In events occurring before operation and allowing to change the status argument, user code can change the status to indicate whether to proceed with the operation, skip or abort it. |
| Tables | Returns the table collection with all data being updated to the database. |
| TableViews | Returns the table view collection with all data being updated to the database. |
| UpdateCommand | For a modified row, the object representing the SQL UPDATE command used to add the row to the database. |
Remarks
The AfterUpdateRow event is fired for every row that fired the BeforeUpdateRow event, regardless of the outcome of the update operation for that row. If row update was unsuccessful, that is reflected in the values of Status, SqlStatus and Error arguments.
This event can be used to change the outcome of the operation from failure to success and vice versa, see the description of the Status, SqlStatus and Error arguments.
This event can also be used to modify values refreshed from the database after the update operation, see the description of the Row argument.
See Also
Reference
BaseLogic Class
BaseLogic Members
C1TableLogic Class
C1DataSetLogic Class
C1ExpressConnection Class
Events in Updating a Row
Events on Updating Database
Bound, SQL-Based and Unbound Tables