UPDATE Where Current of Cursor – PB Docs 2018

UPDATE
Where Current of Cursor

SQL statement

Description

Updates the row in which the cursor is positioned using the values
in SetStatement.

Syntax

UPDATE TableName SetStatement WHERE CURRENT OF CursorName ;

1	UPDATE TableName SetStatement WHERE CURRENT OF CursorName ;

Parameter	Description
TableName	The name of the table in which you want to update the row
SetStatement	The word SET followed by a comma-separated list of the form ColumnName = value
CursorName	The name of the cursor in which the table is referenced

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:

UPDATE Employee
       SET salary = 17800
       WHERE CURRENT of Emp_curs ;

UPDATE Employee

SET salary = 17800

WHERE CURRENT of Emp_curs ;

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2018

August 20, 2023

Was this article helpful?

Connection Information

UPDATE Where Current of Cursor – PB Docs 2018

UPDATE
Where Current of Cursor

SQL statement

My Website Links