Difference between revisions of "SQLEXEC()"
From Recital Documentation Wiki
Barrymavin (Talk | contribs) (→Example) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
SQL Applications | SQL Applications | ||
| Line 15: | Line 12: | ||
==See Also== | ==See Also== | ||
| − | [[CREATE CONNECTION]], [[SQLCANCEL()]], [[SQLCOLUMNS()]], [[SQLCOMMIT()]], [[SQLCONNECT()]], [[SQLDISCONNECT()]], [[SQLGETPROP() | + | [[CREATE CONNECTION]], [[SQLCANCEL()]], [[SQLCOLUMNS()]], [[SQLCOMMIT()]], [[SQLCONNECT()]], [[SQLDISCONNECT()]], [[SQLGETPROP()]], [[SQLMORERESULTS()]], [[SQLPREPARE()]], [[SQLROLLBACK()]], [[SQLSETPROP()]], [[SQLSTRINGCONNECT()]], [[SQLTABLES()]] |
| Line 57: | Line 54: | ||
nStatHand=SQLSTRINGCONNECT("rec@rec1:user1/pass1-/usr/recital/uas/data/southwind.tcpip",.T.) | nStatHand=SQLSTRINGCONNECT("rec@rec1:user1/pass1-/usr/recital/uas/data/southwind.tcpip",.T.) | ||
if nStatHand < 1 | if nStatHand < 1 | ||
| − | + | messagebox("Cannot make connection", 16, "SQL Connect Error") | |
else | 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 | endif | ||
</code> | </code> | ||
Revision as of 12:40, 24 March 2009
Contents
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
