ODBC bind方式取数据的方法

 

1、SQLPrepare()

 int err = SQLPrepare(V_OD_hstmt,(SQLCHAR*)sz,strlen((char *)sz));

 

2、SQLExecute()

  err = SQLExecute(V_OD_hstmt);

 

3、SQLBindCol()
   SQLBindCol(V_OD_hstmt, 1, SQL_C_LONG, &ID, sizeof(ID), &iLen);
   SQLBindCol(V_OD_hstmt, 2, SQL_C_LONG,&SXH, sizeof(SXH), &iLen);

4、SQLFetch()

  int err = SQLFetch(hst);
   if (err == SQL_SUCCESS || err == SQL_SUCCESS_WITH_INFO)
       return 0;
   else
        return -1;