DELETE
Where Current of Cursor
SQL statement
Description
Deletes the row in which the cursor is positioned.
DBMS-specific
Not all DBMSs support DELETE Where Current of Cursor.
Syntax
|
1 |
DELETE FROM TableName WHERE CURRENT OF CursorName; |
|
Parameter |
Description |
|---|---|
|
TableName |
The name of the table from which you want to delete |
|
CursorName |
The name of the cursor in which the table was |
Usage
The USING TransactionObject clause is not allowed with this form
of DELETE Where Current of Cursor; the transaction object was specified
in the statement that declared the cursor.
Error handling
It is good practice to test the success/failure code after
executing a DELETE Where Current of Cursor statement.
Examples
This statement deletes from the Employee table the row in which
the cursor named Emp_cur is positioned:
|
1 |
DELETE FROM Employee WHERE current of Emp_curs ; |
Document get from Powerbuilder help
Thank you for watching.
Subscribe
Login
0 Comments
Oldest