4D v13

ODBC_SQLBindParameter

Home

 
4D v13
ODBC_SQLBindParameter

ODBC_SQLBindParameter 


 

ODBC_SQLBindParameter ( stmtID ; paramNumber ; IOType ; paramType ; columnSize ; decimalDigits ; paramValPtr ; strLenOrIndPtr ) -> Function result 
Parameter Type   Description
stmtID  Longint in Statement ID
paramNumber  Longint in Parameter number, ordered sequentially in increasing parameter order, starting at 1
IOType  Longint in Type of the parameter Input or Output
paramType  Longint in SQL data type of the parameter
columnSize  Longint in The size of the column or expression of the corresponding parameter defined
decimalDigits  Longint in The decimal digits of the column or expression of the corresponding parameter defined
paramValPtr  Pointer in A pointer to a 4D variable or field
strLenOrIndPtr  Pointer in A pointer to the parameter's length if it's a Text value
Function result  Longint in Returns the result of the MS ODBC API function SQLBindParameter

The ODBC_SQLBindParameter command binds a parameter and its value in an SQL Statement.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

paramNumber is the parameter number in the statement defined by ODBC_SQLPrepare, ordered sequentially in increasing parameter order, starting at 1.

IOType defines whether this bind parameter is for input, output, or for input and output and can have one of the following values:

ConstantValue
SQL_PARAM_INPUT 1
SQL_PARAM_INPUT_OUTPUT 2
SQL_PARAM_OUTPUT 4

paramType is the SQL data type of the parameter and can be equal to one of the following values:

ConstantSQL Data Type
SQL_CHAR CHAR
SQL_VARCHAR VARCHAR
SQL_LONGVARCHAR LONG VARCHAR
SQL_DECIMAL DECIMAL
SQL_NUMERIC NUMERIC
SQL_SMALLINT SMALLINT
SQL_INTEGER INTEGER
SQL_REAL REAL
SQL_FLOAT FLOAT
SQL_DOUBLE DOUBLE PRECISION
SQL_BIT BIT
SQL_TINYINT TINYINT
SQL_BIGINT BIGINT
SQL_BINARY BINARY
SQL_VARBINARY VARBINARY
SQL_LONGVARBINARY LONG VARBINARY
SQL_TYPE_DATEDate
SQL_TYPE_TIME Time
SQL_TYPE_TIMESTAMP TIMESTAMP
SQL_INTERVAL_MONTH INTERVAL MONTH
SQL_INTERVAL_YEAR INTERVAL YEAR
SQL_INTERVAL_YEAR_TO_MONTH INTERVAL YEAR TO MONTH
SQL_INTERVAL_DAY INTERVAL DAY
SQL_INTERVAL_HOUR INTERVAL HOUR
SQL_INTERVAL_MINUTE INTERVAL MINUTE
SQL_INTERVAL_SECOND INTERVAL SECOND
SQL_INTERVAL_DAY_TO_HOUR INTERVAL DAY TO HOUR
SQL_INTERVAL_DAY_TO_MINUTE INTERVAL DAY TO MINUTE
SQL_INTERVAL_DAY_TO_SECOND INTERVAL DAY TO SECOND
SQL_INTERVAL_HOUR_TO_MINUTE INTERVAL HOUR TO MINUTE
SQL_INTERVAL_HOUR_TO_SECOND INTERVAL HOUR TO SECOND
SQL_INTERVAL_MINUTE_TO_SECOND INTERVAL MINUTE TO SECOND

columnSize defines the size of the column or expression of the parameter defined.

decimalDigits defines the decimal digits of the column or expression of the parameter defined.

paramValPtr is a pointer to a 4D variable or field.

strLenOrIndPtr is a pointer to a variable that defines the parameter's length if paramType is of type Text, Picture, or BLOB. Use the ODBC_LenDataAtExec command to convert the actual length so that it can be processed by the MS ODBC API.

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

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.

Example  

See the example for the ODBC_SQLExecute command.

 
PROPERTIES 

Product: 4D
Theme: ODBC_Prepare requests
Number: 16977

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D ODBC Pro 2004

 
SEE ALSO 

ODBC_LenDataAtExec
ODBC_SQLPrepare