UPDATE Where Current of Cursor SQL statement
Description
Updates the row in which the cursor is positioned using the
values in SetStatement.
Syntax
|
1 |
UPDATE <span>TableName</span> <span>SetStatement</span> <br> WHERE CURRENT OF <span>CursorName</span> ; |
|
Parameter |
Description |
|---|---|
|
TableName |
The name of the table in which you want |
|
SetStatement |
The word SET followed |
|
CursorName |
The name of the cursor in which the table |
Usage
The USING Transaction Object clause is
not allowed with UPDATE Where Current of Cursor;
the transaction object was specified in the statement that declared
the cursor.
Examples
This statement updates the row in the Employee table
in which the cursor called Emp_curs is
positioned:
|
1 |
UPDATE Employee |
|
1 |
SET salary = 17800 |
|
1 |
WHERE CURRENT of Emp_curs ; |
Document get from Powerbuilder help
Thank you for watching.
Subscribe
Login
0 Comments
Oldest