4D v16

ODBC_SQLExecute

Accueil

 
4D v16
ODBC_SQLExecute

ODBC_SQLExecute 


 

ODBC_SQLExecute ( stmtID ) -> Résultat 
Paramètre Type   Description
stmtID  Entier long in Statement ID
Résultat  Entier long 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.

Exemple  

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)



Voir aussi  

ODBC_SQLBindCol
ODBC_SQLBindParameter
ODBC_SQLGetDiagField
ODBC_SQLGetDiagRec
ODBC_SQLParamData
ODBC_SQLPrepare
ODBC_SQLPutData

 
PROPRIÉTÉS 

Produit : 4D
Thème : ODBC_Submit requests
Numéro : 16970
Nom intl. : ODBC_SQLExecute

 
HISTORIQUE 

Créé : 4D ODBC Pro 2004

 
UTILISATION DE L'ARTICLE

4D ODBC Pro ( 4D v16)