C++ Builder 6 - Database Search

[Rowin]

Hi,
I have a table called event in my database.
I have 2 fields called Event_Id and Project_Id.
I want to search the table to find out if there's event_id=27 for a project_id.

Kind Regards,
Rowin

[tiko_www]

CDatabase* pDatabase ;
...
...
CRecordset m_rs (pDatabase);

m_rs.Open(AFX_DB_USE_DEFAULT_TYPE, "select project_id from table_name where event_id = 27", NULL);

or

m_rs.Open();
m_rs.m_strFilter = "event_id = 27";
m_rs.Requery();


CDBVariant varValue;

while(!m_rs.IsEOF())
{
m_rs.GetFieldValue(2/*2 is column*/, varValue );
...
//cout << varValue.m_lVal;
...

m_rs.MoveNext();
}

[Agregat]

Not sure how MFC fits inside BCB, but whatever

[Rowin]

Thanks, I'll try it.

Kind Regards,
Rowin