Difference between revisions of "SETRESULTSET()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SETRESULTSET()=
 
 
 
==Class==
 
Data Connectivity
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to mark an SQL cursor as a resultset
 
Function to mark an SQL cursor as a resultset
Line 27: Line 20:
 
<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")
  
Line 43: Line 36:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:SQL]]

Latest revision as of 16:20, 7 December 2009

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, Recital Server