SQLINTEGER cbsatid=SQL_NTS;
while (SQLFetch(hstmt)!=SQL_NO_DATA_FOUND)
{
SQLCHAR name[20];
SQLGetData(hstmt,1,SQL_C_CHAR,name,20,&cbsatid);
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);
}