When i'm opening an ODBC cursor and querying a value, i often get blank values in columns i know contain data..
I open the cursors as forwardonly/static, and i know that records are returned.
Could this be a memory violation?
Code:
char *RecSet::GetData(short colNum){
char *retVal = new char[101];
long lLen(0);
short sRes(0);
sRes=SQLGetData(this->m_hStmt, colNum, SQL_C_CHAR, retVal, 100, &lLen);
if(sRes != SQL_SUCCESS && sRes != SQL_SUCCESS_WITH_INFO){
delete [] retVal;
return(0);
}
return(retVal);
}