hi all
i am using SQLBindparameter to bind parameters to the prepare statement.but it allocates the handle and prepares a SQL statement but gives error in Binding.
i am including my code here.
void COdbctestView:😮nTest()
{
SQLRETURN sr;
SQLHSTMT hstmt;
SQLCHAR SQL[200]= "INSERT into user2(username,systemname) Values(?,?)";
char user[] = "india";
char system[] = "rupee";
SQLINTEGER userLength = SQL_NTS;
SQLINTEGER systemLength = SQL_NTS;
sr = SQLAllocHandle(SQL_HANDLE_STMT,hDbConn,&hstmt);
if(sr != SQL_SUCCESS && sr != SQL_SUCCESS_WITH_INFO)
displayODBCError(sr,"Error in Allocating Handle");
sr = SQLPrepare(hstmt,SQL,SQL_NTS);
if(sr != SQL_SUCCESS && sr != SQL_SUCCESS_WITH_INFO)
displayODBCError(sr,"error in preparing sql insert");
sr = SQLBindParameter( hstmt,1,SQL_PARAM_INPUT_OUTPUT,SQL_C_CHAR,SQL_CHAR,0,0,user,sizeof(user),&userLength);
if(sr != SQL_SUCCESS && sr != SQL_SUCCESS_WITH_INFO)
displayODBCError(sr,"error in binding parameter1");
sr = SQLBindParameter(hstmt,2,SQL_PARAM_INPUT_OUTPUT,SQL_C_CHAR,SQL_CHAR,0,0,system,sizeof(system),&systemLength);
if(sr != SQL_SUCCESS && sr != SQL_SUCCESS_WITH_INFO)
displayODBCError(sr,"error in binding parameter2");
sr= SQLExecute(hstmt);
if(sr != SQL_SUCCESS && sr != SQL_SUCCESS_WITH_INFO)
displayODBCError(sr,"error in Executing");
SQLFreeHandle(SQL_HANDLE_STMT,hstmt);
}
