ESL Documentation

Navigation: » No topics above this level «

WHERE CURRENT OF Clause Dialog Box

Use this dialog box to add the WHERE CURRENT OF clause to a positioned UPDATE or positioned DELETE statement.

WhereCurrent
The WHERE CURRENT OF clause updates a single row of data pointed to by the current cursor position.

SELECT Statement	Lists the names of the SELECT statements in the current SQL Access Module (SAM).
Cursor	Lists the names of the cursors defined in the current SAM for each SELECT statement.
OK	Adds the WHERE CURRENT OF clause to the current statement in the SQL Editor window.
Cancel	Closes the dialog box without performing any action.
Help	Displays help for the dialog box.

This dialog box appears automatically for:

•Positioned UPDATE statements after you select the OK push button in the UPDATE/SET Clause dialog box

•Positioned DELETE statements after you select the OK push button in the DELETE/FROM Clause dialog box

You can display this dialog box for positioned UPDATE or positioned DELETE statements by selecting SQL Statement>Where or the Where button.