SQLMORERESULTS()

From Recital Documentation Wiki
Revision as of 16:15, 4 July 2011 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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