Difference between revisions of "SQLEXEC()"

From Recital Documentation Wiki
Jump to: navigation, search
(Example)
 
(8 intermediate revisions by 3 users not shown)
Line 1: Line 1:
=SQLEXEC()=
 
 
 
==Class==
 
SQL Applications
 
 
 
 
==Purpose==
 
==Purpose==
 
Send an SQL statement to a data source
 
Send an SQL statement to a data source
Line 11: Line 4:
  
 
==Syntax==
 
==Syntax==
SQLEXEC(<nStatementHandle>, [<cSQLCommand>, [<cCursorName>]])
+
SQLEXEC(<nStatementHandle> [, <cSQLCommand> [, <cCursorName>]])
  
  
 
==See Also==
 
==See Also==
[[CREATE CONNECTION]], [[SQLCANCEL()]], [[SQLCOLUMNS()]], [[SQLCOMMIT()]], [[SQLCONNECT()]], [[SQLDISCONNECT()]], [[SQLGETPROP(),]] [[SQLMORERESULTS()]], [[SQLPREPARE()]], [[SQLROLLBACK()]], [[SQLSETPROP()]], [[SQLSTRINGCONNECT()]], [[SQLTABLES()]]
+
[[CREATE CONNECTION]], [[SQLCANCEL()]], [[SQLCOLUMNS()]], [[SQLCOMMIT()]], [[SQLCONNECT()]], [[SQLDISCONNECT()]], [[SQLERROR()]], [[SQLGETPROP()]], [[SQLMORERESULTS()]], [[SQLPREPARE()]], [[SQLROLLBACK()]], [[SQLSETPROP()]], [[SQLSTRINGCONNECT()]], [[SQLTABLES()]]
  
  
Line 21: Line 14:
 
The SQLEXEC() function is used to send an SQL statement to the specified data source.
 
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>.
+
The SQLEXEC() function operates on the data source specified by <nStatementHandle>.  The [[SQLERROR()]] function can be used to return the error message if the SQL statement fails.
  
  
Line 48: Line 41:
 
|1||SQLEXEC() finished executing
 
|1||SQLEXEC() finished executing
 
|-
 
|-
|&ndash;1||Connection error
+
|&#045;1||Connection error
 
|-
 
|-
 
|}
 
|}
Line 55: Line 48:
 
==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-/usr/recital/uas/data/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")
 
else
 
else
  messagebox('Connection made', 48, 'SQL Connect Message')
+
    messagebox('Connection made', 48, 'SQL Connect Message')
  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")
  browse
+
    browse
  SQLDISCONNECT(nStatHand)
+
    SQLDISCONNECT(nStatHand)
 
endif
 
endif
 
</code>
 
</code>
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:SQL]]
 
[[Category:SQL]]
 +
[[Category:Remote Data Connectivity Functions]]

Latest revision as of 15:39, 4 July 2011

Purpose

Send an SQL statement to a data source


Syntax

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


See Also

CREATE CONNECTION, SQLCANCEL(), SQLCOLUMNS(), SQLCOMMIT(), SQLCONNECT(), SQLDISCONNECT(), SQLERROR(), 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>. The SQLERROR() function can be used to return the error message if the SQL statement fails.


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, Recital Server