views:

193

answers:

0

Hi

we are developing Vc++ project while executing this

strSQL = _T("SELECT * FROM tblTestInfo_SI ") _T(" WHERE (idOnLineStatus = 1)"); while passing this query through below function shows some error. idOnLineStatus this datatype is number

bSuccess = m_prsTestInfoSI->Open( CRecordset::dynaset, strSQL, CRecordset::none );

DBMS: ACCESS Version: 04.00.0000 ODBC Driver Manager Version: 03.52.0000 Error: fetching row from server. Error in row Restricted data type attribute violation on column number 185 (idO nLineStatus)

please help me advance thanks