Difference between revisions of "GETRESULTSET()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
==Class==
 
SQL Applications
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to return the workarea number of an SQL cursor previously marked as a resultset
 
Function to return the workarea number of an SQL cursor previously marked as a resultset
Line 43: Line 39:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:SQL]]
 
[[Category:SQL]]

Latest revision as of 16:17, 2 December 2009

Purpose

Function to return the workarea number of an SQL cursor previously marked as a resultset


Syntax

GETRESULTSET()


See Also

CLEARRESULTSET(), SELECT, SETRESULTSET()


Description

The GETRESULTSET() function returns the workarea number of an SQL cursor previously marked as a resultset by the SETRESULTSET() function. The SETRESULTSET() function is particularly used in returning a resultset from a stored procedure in SQL client/server applications.

GETRESULTSET() will return 0 (zero) if no SQL cursor is currently marked as a resultset. The marker can be cleared from an SQL cursor using the CLEARRESULTSET() function.


Example

function GetExampleCursor
  lparameters lcAccountNo
  select * from example where account_no = lcAccountNo into cursor curExample
return setresultset("curExample")
 
open database southwind
GetExampleCursor("00050")
? "Returned resultset is in work area #" + ltrim(str(getresultset()))
set sql off
select getresultset()
display all
? "Cleared resultset marker in work area #" + ltrim(str(clearresultset()))
? iif(getresultset() > 0,"Resultset available in work area #" + ltrim(str(getresultset())),;
 "No resultsets available")
?
close databases


Products

Recital Server, Recital