4D v13

ODBC_SQLExecute

Home

 
4D v13
ODBC_SQLExecute

ODBC_SQLExecute 


 

ODBC_SQLExecute ( stmtID ) -> Function result 
Parameter Type   Description
stmtID  Longint in Statement ID
Function result  Longint in Returns the result of the MS ODBC API function SQLExecute

The ODBC_SQLExecute command executes a prepared statement, using the current values of the parameter marker variables if any parameter markers exist in the statement.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

For more information, please see the SQLExecute function in the MS ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms713584(VS.85).aspx.

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_NEED_DATA, SQL_STILL_EXECUTING, SQL_ERROR, SQL_NO_DATA, or SQL_INVALID_HANDLE.

If ODBC_SQLExecute returns SQL_NEED_DATA, you can use the ODBC_SQLParamData and ODBC_SQLPutData commands.

Example  

The following method creates a bind with our data source's Employee table and its four fields specified by the ODBC_SQLPrepare command and then inserts the data defined in the ODBC_SQLBindParameter command once the statement is executed:

 $result:=ODBC_SQLPrepare($statementID;"INSERT INTO Employee (ID, Name, Hire_Date,
 Current_Employee)VALUES(?,?,?,?)")
 
 vEmployeeHireDate:=Current date
 vEmployeeID:=6
 vEmployeeFullname:="Betty Jones"
 vEmployeeCurrent:=True
 
 $result:=ODBC_SQLBindParameter($statementID;1;1;SQL_SMALLINT;0;0;->vEmployeeID)
 $result:=ODBC_SQLBindParameter($statementID;2;1;SQL_CHAR;10;0;->vEmployeeFullname)
 $result:=ODBC_SQLBindParameter($statementID;3;1;SQL_TYPE_DATE;0;0;->vEmployeeHireDate)
 $result:=ODBC_SQLBindParameter($statementID;4;1;SQL_BIT;0;0;->vEmployeeCurrent)
 
 $result:=ODBC_SQLNumParams($statementID;$numparams)
 $result:=ODBC_SQLExecute($statementID)

 
PROPERTIES 

Product: 4D
Theme: ODBC_Submit requests
Number: 16970

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D ODBC Pro 2004

 
SEE ALSO 

ODBC_SQLBindCol
ODBC_SQLBindParameter
ODBC_SQLGetDiagField
ODBC_SQLGetDiagRec
ODBC_SQLParamData
ODBC_SQLPrepare
ODBC_SQLPutData