DeleteRow (ODBCResultSet - LotusScript)
Deletes the record represented by the current row of the result set from the specified table in the external database.
Defined in
Syntax
status = odbcResultSet . DeleteRow( tableName$ )
Parameters
tableName$
String. The name of the table in which you want to delete the record.
Return value
status
Boolean.
Usage
The DeleteRow method may not be possible if the result or database is read-only.
DeleteRow does not change the value of NumRows, so row numbers from CurrentRow do not need to be recalculated.
The tableName$ parameter is required to prevent ambiguity when forming an SQL statement for the data source.
This statement can fail when the result set includes columns with Image or Rich Text data types or when rows are not identified uniquely. To avoid these failures, see "Working with data retrieved from an external database" in LotusScript Classes Coding Guidelines."
Errors
Invalid row number (DBstsINVR)
Update or Delete cannot locate a unique data row (DBstsNUNQ)
Read only. Data cannot be updated or deleted (DBstsRDON)
This method might raise an error about not being applicable to the AddRow workspace in some cases where another error message applies.
Events
BeforeDeleteRow
AfterDeleteRow
Language cross-reference
EditTableDeleteRowColumn @command in formula language