Difference between revisions of "SQLMORERESULTS()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(2 intermediate revisions by one user not shown)
Line 8: Line 8:
  
 
==See Also==
 
==See Also==
[[CREATE CONNECTION]], [[SQLCANCEL()]], [[SQLCOLUMNS()]], [[SQLCOMMIT()]], [[SQLCONNECT()]], [[SQLDISCONNECT()]], [[SQLEXEC()]], [[SQLGETPROP()]], [[SQLPREPARE()]], [[SQLROLLBACK()]], [[SQLSETPROP()]], [[SQLSTRINGCONNECT()]], [[SQLTABLES()]]
+
[[CREATE CONNECTION]], [[SQLCANCEL()]], [[SQLCOLUMNS()]], [[SQLCOMMIT()]], [[SQLCONNECT()]], [[SQLDISCONNECT()]], [[SQLERROR()]], [[SQLEXEC()]], [[SQLGETPROP()]], [[SQLPREPARE()]], [[SQLROLLBACK()]], [[SQLSETPROP()]], [[SQLSTRINGCONNECT()]], [[SQLTABLES()]]
  
  
Line 49: Line 49:
 
==Example==
 
==Example==
 
<code lang="recital">
 
<code lang="recital">
nStatHand=SQLSTRINGCONNECT("rec@rec1:user1/pass1/usr/recital/uas/data/southwind.tcpip",.T.)
+
nStatHand=SQLSTRINGCONNECT("rec@rec1:user1/pass1-southwind.tcpip",.T.)
 
if nStatHand < 1
 
if nStatHand < 1
 
   messagebox('Cannot make connection', 16, 'SQL Connect Error')
 
   messagebox('Cannot make connection', 16, 'SQL Connect Error')
Line 56: Line 56:
 
   store "00010" to myVar
 
   store "00010" to myVar
 
   SQLEXEC(nStatHand, "SELECT * FROM example WHERE account_no = ?myVar", "restab")
 
   SQLEXEC(nStatHand, "SELECT * FROM example WHERE account_no = ?myVar", "restab")
 +
  display all
 
   SQLMORERESULTS(nStatHand)
 
   SQLMORERESULTS(nStatHand)
  browse
 
 
   SQLDISCONNECT(nStatHand)
 
   SQLDISCONNECT(nStatHand)
 
endif
 
endif
 
</code>
 
</code>
 
  
 
==Products==
 
==Products==

Latest revision as of 16:15, 4 July 2011

Purpose

Check if more results sets are available and if so, copy next results set to a cursor


Syntax

SQLMORERESULTS(<nStatementHandle>)


See Also

CREATE CONNECTION, SQLCANCEL(), SQLCOLUMNS(), SQLCOMMIT(), SQLCONNECT(), SQLDISCONNECT(), SQLERROR(), SQLEXEC(), SQLGETPROP(), SQLPREPARE(), SQLROLLBACK(), SQLSETPROP(), SQLSTRINGCONNECT(), SQLTABLES()


Description

The SQLMORERESULTS() function is used in non-BatchMode to check whether more results sets are available and if so, to copy the next results set to a cursor. BatchMode is set using the SQLSETPROP() function. BatchMode is always True and cannot be used to return results sets individually. It is included for compatibility reasons only.

The SQLMORERESULTS() function operates on the data source specified by <nStatementHandle>.


Keywords Description
nStatementHandle The workarea in which the gateway data source is open


Valid Return values:

Return Value Description
2 No more data found
1 SQL statement has finished executing
0 SQL statement is still executing
–1 Connection error
–2 Environment error


SQLMORERESULTS() always returns 2.


Example

nStatHand=SQLSTRINGCONNECT("rec@rec1:user1/pass1-southwind.tcpip",.T.)
if nStatHand < 1
  messagebox('Cannot make connection', 16, 'SQL Connect Error')
else
  messagebox('Connection made', 48, 'SQL Connect Message')
  store "00010" to myVar
  SQLEXEC(nStatHand, "SELECT * FROM example WHERE account_no = ?myVar", "restab")
  display all
  SQLMORERESULTS(nStatHand)
  SQLDISCONNECT(nStatHand)
endif

Products

Recital, Recital Server