C语言ODBC处理数据库结果集

SQLINTEGER cbsatid=SQL_NTS;

while (SQLFetch(hstmt)!=SQL_NO_DATA_FOUND)
{
SQLCHAR name[20];
SQLGetData(hstmt,1,SQL_C_CHAR,name,20,&cbsatid);

} 

//--------------------------------------------------------------------------------------------------------

SQLINTEGER cbsatid=SQL_NTS;


while (SQLFetch(hstmt)!=SQL_NO_DATA_FOUND)
{
SQLINTEGER i;
SSQLGetData(hstmt,2,SQL_C_LONG,&i,sizeof(SQLINTEGER),&cbsatid);
}