Column BookID doesn't exist.

From:

sheikh <iceage2004@gmail.com>

Newsgroups:

microsoft.public.vc.mfc

Date:

Tue, 16 Sep 2008 07:25:10 -0700 (PDT)

Message-ID:

<ac68298e-5863-47af-8a6e-99bac3b47400@y38g2000hsy.googlegroups.com>

HI friends

i am again here with my problem.I have written a code which is
compiled without error,But when i want to debug it ,it shows the error
Column "BookID" doesn't exist.
I dont know why,
Becoz in my Databank there is Column BookID.
It is my code:

void CBookInformationView::DoDataExchange(CDataExchange* pDX)
{
    CRecordView::DoDataExchange(pDX);
    // you can insert DDX_Field* functions here to 'connect' your
controls to the database fields, ex.
    DDX_FieldText(pDX, IDC_TITLE, m_pSet->m_BookTitle, m_pSet);
    DDX_FieldText(pDX, IDC_CATEGORY, m_pSet->m_Category, m_pSet);
    DDX_FieldText(pDX, IDC_RATING, m_pSet->m_Rating, m_pSet);
    DDX_FieldText(pDX, IDC_NOTES, m_pSet->m_Notes, m_pSet);
    // DDX_FieldCheck(pDX, IDC_MYCHECKBOX, m_pSet->m_bColumn2, m_pSet);
    // See MSDN and ODBC samples for more information
    DDX_Control(pDX, IDC_Author, m_Author_control);
    UpdateAuthor(m_pSet->m_BookID);
}
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
bool CBookInformationView::UpdateAuthor(int id)
{
    CAuthorRecordSet ars;
    CBookAuthorRecordSet bars;
    CString bookauthorSQL;
    CString authorSQL;
    CString display;
    int pos;

    m_Author_control.ResetContent();

    bookauthorSQL.Format(_T("BookID=%d"),id);
    bars.m_strFilter = bookauthorSQL;
    bars.Open();

    while (!bars.IsEOF())
    {
        authorSQL.Format (_T("AuthorID=%d"),bars.m_AuthorID);
        ars.m_strFilter= authorSQL;
        if ( ars.IsOpen())
            ars.Requery();
        else
            ars.Open();
        display = ars.m_AuthorName;
        pos = m_Author_control.AddString(display);
        bars.MoveNext();
    }

    return true;
}

i am very thankful to u all