Difference between revisions of "CLEARRESULTSET()"

From Recital Documentation Wiki
Jump to: navigation, search
Line 23: Line 23:
 
<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 clear the marker from an SQL cursor previously marked as a resultset


Syntax

CLEARRESULTSET()


See Also

GETRESULTSET(), SELECT, SETRESULTSET()

Description

The CLEARRESULTSET() function clears the marker from 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.

CLEARRESULTSET() will return the workarea number of the SQL cursor from which the marker was cleared, or 0 (zero) if no SQL cursor was marked as a resultset.


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