Click or drag to resize

SQLSelect.Delete Method

X#
Delete the current row.

Namespace:  VO
Assembly:  VOSQLClasses (in VOSQLClasses.dll) Version: 2.21
Syntax
 VIRTUAL METHOD Delete() AS USUAL
Request Example View Source

Return Value

Type: Usual
TRUE if successful; otherwise, FALSE.
Remarks
The row is not deleted until the Commit() is invoked and is not deleted if Rollback() is invoked. Delete() sends a NotifyRecordChange message if successful. If the server is currently positioned on the append buffer, SQLSelect:Delete() will cancel the pending update. The type of SQL statement (searched or positioned) used by Delete() is determined by the system automatically, unless set to cursor, key, or value, using SQLSelect:ScrollUpdateType.
Tip Tip
If the type of SQL statement used by SQLSelect:Delete() is "value", more than one row may be deleted, since the rows that are deleted are based on matching this value.
See Also