ODBC_SQLBindParameter

4D v16


ODBC_SQLBindParameter ( stmtID ; paramNumber ; IOType ; tipoParam ; columnSize ; decimalDigits ; paramValPtr ; strLenOrIndPtr ) -> Resultado

Parámetro	Tipo	Descripción
stmtID	Entero largo	Statement ID
paramNumber	Entero largo	Parameter number, ordered sequentially in increasing parameter order, starting at 1
IOType	Entero largo	Type of the parameter Input or Output
tipoParam	Entero largo	SQL data type of the parameter
columnSize	Entero largo	The size of the column or expression of the corresponding parameter defined
decimalDigits	Entero largo	The decimal digits of the column or expression of the corresponding parameter defined
paramValPtr	Puntero	A pointer to a 4D variable or field
strLenOrIndPtr	Puntero	A pointer to the parameter's length if it's a Text value
Resultado	Entero largo	Returns the result of the MS ODBC API function SQLBindParameter

Descripción

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:

Constant	Value
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:

Constant	SQL 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_DATE	Date
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.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.

Ejemplo

See the example for the ODBC_SQLExecute command.

Ver también

ODBC_LenDataAtExec
ODBC_SQLPrepare