Oracle 8.1.7.7 ODBC Driver CRecordset::Requery is fetching zero records
Hi,
Environment
Oracle 8.1.7 Database on Windows 2000
MFC Application using ODBC 8.1.7.7 Driver
Sample Code:
===============================================
m_strFilter = "COLUMN1 = ? AND COLUMN2 = ?" ;
m_strSort.Empty( ) ;
m_COLUMN1 = "Value1" ;
m_COLUMN2 = "Value2" ;
if( !Requery( ) )
return FALSE ;
else if( !IsEOF( ) )
===============================================
a CRecordset::Requery is failing to fetch rows
from the Table while the records are present.
Oracle ODBC driver Version 8.1.5 on Windows NT
works fine.
Somehow when ODBC driver version 8.1.7.7 on
Windows 2000 is used, MFC Application using
CRecordset fails to fetch records using Requery!
Any Help is appreciated.
Thanks
Subu