View source for GETRESULTSET()

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


==Syntax==
GETRESULTSET()


==See Also==
[[CLEARRESULTSET()]], [[SQL SELECT|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==
<code lang="recital">
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
</code>


==Products==
Recital Server, Recital 
[[Category:Documentation]]
[[Category:Functions]]
[[Category:SQL]]