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 <span>TableName</span> WHERE CURRENT OF <span>CursorName</span>; |
|
Parameter |
Description |
|---|---|
|
TableName |
The name of the table from which you |
|
CursorName |
The name of the cursor in which the table |
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