- 论坛徽章:
- 5
|
30可用积分
本帖最后由 光速 于 2011-01-20 15:59 编辑
数据表locateVFName 中有一个字符型的字段,有四条记录,如下:
201010010111
201010010112
201010010113
201010010114
char locateVF[20]={0};
SQLINTEGER cb=SQL_NTS;
int recordTotal=0;//记录总数
char selectStr[]="select locateVFName from IsPassServer_t ";
connectDB_ACCESS(); //连接ACCESS
retcode = SQLExecDirect(hstmt,(SQLCHAR *)selectStr,SQL_NTS);
//获得记录总数
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
{
while ((retcode = SQLFetch(hstmt) ) != SQL_NO_DATA)
{
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
{
recordTotal++;
}
}
}
retcode =SQLFetchScroll(hstmt, SQL_FETCH_FIRST, 0); //现在定位到记录集第一行
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
{
retcode=SQLBindCol(hstmt,1,SQL_C_CHAR,locateVF,20,&cb);
while (TRUE)
{
retcode = SQLFetch(hstmt);
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
{
MessageBox(NULL,locateVF,"test",MB_OK);
}
}
}
从MessageBox(NULL,locateVF,"test",MB_OK);看显示的记录值不是第一条记录的201010010111 ,而是显示的201010010112
这是怎么回事? |
|