SQL IF STATEMENT HELP PLEASE

[Guest_imported]

I have a SQL statement, where it looks for a matching record on a given user value.

How can i implement a If statement, if no matching records where found, to notify user that there is no records.

my code.

reSet.Open(dbOpenDynaset,SQL);
//Tried
if (reSet.IsEOF())
and
if (reSet == NULL)
{
AfxMessageBox(No record Found);
}

Did not work, can someone pls help me.
thanks in advance.

 

[Zyrenthian]

before you do anything check

if(!reSet.GetCount())
{
// no records
}
else
{

// you have records

}

Matt

 

[Guest_imported]

Thanks Mat,

It works fine..

You ment if(!reSet.GetRecordCount())

Thanks Again.