Hi gurus!
I use CRecordSet to insert/read the data from the database.

I am inserting the file name into the database.
before I insert the file to the database I want to find out whether the file is already exit in the database. the files might have the different but they content of the files are the same. So I try to get each file name from the db and compare with the file about to insert.

I use the following code but the message box is displaying empty string eventhough the data are there in the db.


myRecordSet->m_pDatabase->ExecuteSQL("Select fileName from myTable");
while(!myRecordSet->IsEOF())
{
//doing comparing here
MessageBox(myRecordSet->fileName);
myRecordSet->MoveNext();
}

please poing me out what/where am i doing wrong?

thanks