Difference between revisions of "SQLEXEC()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 52: | Line 52: | ||
m_balance = 12345.67 | m_balance = 12345.67 | ||
SQLEXEC(nStatHand,"INSERT INTO dbo.doc1 (ACCOUNT_NO,lastname,balance) VALUES ('&m_accno','&m_lastname',&m_balance)") | SQLEXEC(nStatHand,"INSERT INTO dbo.doc1 (ACCOUNT_NO,lastname,balance) VALUES ('&m_accno','&m_lastname',&m_balance)") | ||
+ | messagebox("Record inserted") | ||
nRET=SQLEXEC(nStatHand,"SELECT * from dbo.doc1","mycursor") | nRET=SQLEXEC(nStatHand,"SELECT * from dbo.doc1","mycursor") | ||
if nRET = -1 | if nRET = -1 | ||
Line 57: | Line 58: | ||
else | else | ||
messagebox("Record selected") | messagebox("Record selected") | ||
+ | list | ||
+ | endif | ||
+ | // Using prepared statement | ||
+ | sqlprepare(nStatHand,"select * from dbo.doc1 where account_no = ?m_accno","mycursor") | ||
+ | nRET=SQLEXEC(nStatHand) | ||
+ | if nRET < 1 | ||
+ | messagebox(sqlerror(nstatHand)) | ||
+ | else | ||
+ | messagebox("Record selected using prepared statement") | ||
list | list | ||
endif | endif |
Revision as of 09:49, 7 January 2013
Purpose
Send an SQL statement to a data source
Syntax
SQLEXEC(<nStatementHandle> [, <cSQLCommand> [, <cCursorName>]])
See Also
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=SQLCONNECT("awhr") if nStatHand < 1 messagebox("Cannot make connection", 16, "SQL Connect Error") else messagebox("Connection made", 48, "SQL Connect Message") SQLEXEC(nStatHand,"create table doc1 (ACCOUNT_NO char(5), lastname char(25), balance dec(10,2))") messagebox("Table created") m_accno = "00699" m_lastname = "Smith" m_balance = 12345.67 SQLEXEC(nStatHand,"INSERT INTO dbo.doc1 (ACCOUNT_NO,lastname,balance) VALUES ('&m_accno','&m_lastname',&m_balance)") messagebox("Record inserted") nRET=SQLEXEC(nStatHand,"SELECT * from dbo.doc1","mycursor") if nRET = -1 messagebox(sqlerror(nstatHand)) else messagebox("Record selected") list endif // Using prepared statement sqlprepare(nStatHand,"select * from dbo.doc1 where account_no = ?m_accno","mycursor") nRET=SQLEXEC(nStatHand) if nRET < 1 messagebox(sqlerror(nstatHand)) else messagebox("Record selected using prepared statement") list endif SQLDISCONNECT(nStatHand) endif