SQLEXEC()

SQLEXEC()

Class

SQL Applications

Purpose

Send an SQL statement to a data source

Syntax

SQLEXEC(<nStatementHandle>, [<cSQLCommand>, [<cCursorName>]])

See Also

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

Description

The SQLEXEC() function is used to send an SQL statement to the specified data source.

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

Keywords	Description
nStatementHandle	The workarea in which the gateway data source is open.
cSQLCommand	The SQL statement to be passed to the data source. The cSQLCommand can be omitted if the SQL statement has already been set up using SQLPREPARE().
cCursorName	The name of the temporary table to use. If cCursorName is not specified, the default name SQLRESULT is used. If the SQLEXEC() is running a pre-prepared statement, the cCursorName is taken from the SQLPREPARE() setting.

Return values:

Return Value	Description
<n>	Number of results sets if more than 1
0	SQLEXEC() is still executing
1	SQLEXEC() finished executing
–1	Connection error

Example

nStatHand=SQLSTRINGCONNECT("rec@rec1:user1/pass1:/usr/recital/uas/data/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")
  browse
  SQLDISCONNECT(nStatHand)
endif

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer