SQLMORERESULTS()

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