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