Deletes the record represented by the current row of the result set from the specified table in the external database.

Defined in

ODBCResultSet

Syntax

status = odbcResultSet.DeleteRow( tableName$ )

Parameters

tableName$

String. The name of the table in which you want to delete the record.

status

Boolean.

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

Example
See Also

Close method
GetRowStatus method
IsSupported method (in ODBCConnection)
ReadOnly property

Glossary