4D v16

ODBC_SQLDescribeParam

Accueil

 
4D v16
ODBC_SQLDescribeParam

ODBC_SQLDescribeParam 


 

ODBC_SQLDescribeParam ( stmtID ; paramNb ; typeDonnées ; paramSize ; decimalDigits ; nullable ) -> Résultat 
Paramètre Type   Description
stmtID  Entier long in Statement ID
paramNb  Entier long in Parameter marker number ordered sequentially in increasing parameter order, starting at 1
typeDonnées  Entier long in SQL data type of the parameter
paramSize  Entier long in Size of the column or expression of the corresponding parameter marker as defined by the data source
decimalDigits  Entier long in Number of decimal digits of the column or expression of the corresponding parameter as defined by the data source
nullable  Entier long in Indicates whether the parameter allows NULL values
Résultat  Entier long in Returns the result of the MS ODBC API function SQLDescribeParam

The ODBC_SQLDescribeParam command returns the description of a parameter associated with a prepared SQL statement.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

paramNb is the parameter marker number ordered sequentially in increasing parameter order, starting at 1.

dataType is the SQL data type of the parameter. See the ODBC_SQLGetTypeInfo command for possible data types.

paramSize is the size of the column or expression.

decimalDigits is the number of decimal digits of the column or expression.

The nullable parameter indicates whether the parameter allows NULL values and can be equal to one of the following values:

ConstantDescription
SQL_NO_NULLSDoes not allow NULL values
SQL_NULLABLEAllows NULL values
SQL_NULLABLE_UNKNOWNDriver cannot determine if the parameter allows NULL values

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

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.



Voir aussi  

ODBC_SQLGetTypeInfo

 
PROPRIÉTÉS 

Produit : 4D
Thème : ODBC_Submit requests
Numéro : 16972
Nom intl. : ODBC_SQLDescribeParam

 
HISTORIQUE 

Créé : 4D ODBC Pro 2004

 
UTILISATION DE L'ARTICLE

4D ODBC Pro ( 4D v16)