Difference between revisions of "CURSORNAME()"
From Recital Documentation Wiki
Helengeorge (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 18: | Line 18: | ||
<code lang="recital"> | <code lang="recital"> | ||
set gateway to "ora@sales:scott/tiger" | set gateway to "ora@sales:scott/tiger" | ||
| − | + | declare employees; | |
| − | + | cursor for; | |
| − | select empno, ename, job | + | select empno, ename, job; |
| − | from emp | + | from emp; |
| − | order by deptno | + | order by deptno |
| − | + | open employees | |
| − | + | ||
? cursorname() | ? cursorname() | ||
Revision as of 11:30, 23 December 2009
Purpose
Function to return the name of the cursor open in a workarea with an active gateway
Syntax
CURSORNAME([<workarea | alias>])
See Also
CLOSE, DECLARE CURSOR, DROP CURSOR, FETCH, FINDCURSOR(), GATEWAY(), OPEN
Description
The CURSORNAME() function returns the cursor name corresponding to the workarea specified by <workarea | alias>. If there is no cursor open, or no gateway active in the specified workarea then an empty string is returned. If no <workarea | alias> is specified then the CURSORNAME() function defaults to the current workarea.
Example
set gateway to "ora@sales:scott/tiger" declare employees; cursor for; select empno, ename, job; from emp; order by deptno open employees ? cursorname() EMPLOYEES
Products
Recital Server, Recital
