Difference between revisions of "GETRESULTSET()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
m (Text replace - "Recital" to "Lianja") |
||
Line 39: | Line 39: | ||
==Products== | ==Products== | ||
− | + | Lianja Server, Lianja | |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:SQL]] | [[Category:SQL]] |
Revision as of 13:05, 7 December 2012
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
Lianja Server, Lianja