Index: driver/prepare.c =================================================================== --- driver/prepare.c (revision 1020) +++ driver/prepare.c (working copy) @@ -292,6 +292,37 @@ } +/** + Deprecated function, for more details see SQLBindParamater. + + @param[in] stmt Handle to statement + @param[in] ipar Parameter number + @param[in] fCType Value type + @param[in] fSqlType Parameter type + @param[in] cbColDef Column size + @param[in] ibScale Decimal digits + @param[in] rgbValue Parameter value pointer + @param[in] pcbValue String length or index pointer + + @return SQL_SUCCESS or SQL_ERROR (and diag is set) + +*/ + +SQLRETURN SQL_API SQLSetParam(SQLHSTMT hstmt, + SQLUSMALLINT ipar, + SQLSMALLINT fCType, + SQLSMALLINT fSqlType, + SQLULEN cbColDef, + SQLSMALLINT ibScale, + SQLPOINTER rgbValue, + SQLLEN * pcbValue) +{ + return my_SQLBindParameter(hstmt, ipar, SQL_PARAM_INPUT_OUTPUT, fCType, + fSqlType, cbColDef, ibScale, rgbValue, + SQL_SETPARAM_VALUE_MAX, pcbValue); +} + + /* @type : ODBC 2.0 API @purpose : binds a buffer to a parameter marker in an SQL statement. Index: driver/myodbc3.def =================================================================== --- driver/myodbc3.def (revision 1020) +++ driver/myodbc3.def (working copy) @@ -118,6 +118,7 @@ ;SQLGetDescField ;SQLGetDescRec SQLCloseCursor +SQLSetParam ; DllMain LoadByOrdinal Index: test/my_prepare.c =================================================================== --- test/my_prepare.c (revision 1020) +++ test/my_prepare.c (working copy) @@ -1062,6 +1062,10 @@ ok_stmt(hstmt, SQLSetParam(hstmt, 1, SQL_C_CHAR, SQL_INTEGER, 10, 0, param, 0)); ok_sql(hstmt, "SELECT * FROM t_bug29871 WHERE a=?"); + ok_stmt(hstmt, SQLFetch(hstmt)); + is_num(my_fetch_int(hstmt, 1), 1); + + ok_stmt(hstmt, SQLFreeStmt(hstmt, SQL_CLOSE)); ok_sql(hstmt, "DROP TABLE t_bug29871"); return OK; }