Difference between revisions of "SETRESULTSET()"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
| − | + | SQL Applications | |
| Line 27: | Line 24: | ||
<code lang="recital"> | <code lang="recital"> | ||
function GetExampleCursor | function GetExampleCursor | ||
| − | lparameters lcAccountNo | + | lparameters lcAccountNo |
| − | select * from example where account_no = lcAccountNo into cursor curExample | + | select * from example where account_no = lcAccountNo into cursor curExample |
return setresultset("curExample") | return setresultset("curExample") | ||
Revision as of 11:09, 3 June 2009
Class
SQL Applications
Purpose
Function to mark an SQL cursor as a resultset
Syntax
SETRESULTSET(<expN>|<expC>)
See Also
CLEARRESULTSET(), GETRESULTSET(), SQL SELECT
Description
The SETRESULTSET() function marks an SQL cursor as a resultset. Any previous SQL cursor marker is cleared. The workarea number or alias name of the cursor should be specified in <expN> or <expC> respectively. The SETRESULTSET() function is particularly used in returning a resultset from a stored procedure in SQL client/server applications.
The GETRESULTSET() function can be used to return the workarea number of an SQL cursor marked as a resultset by SETRESULTSET(). The resultset 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") select * from curexample ? "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 Database Server, Recital Mirage Server, Recital Terminal Developer
