Syntax error in FROM clause

See more:

C++

MFC

ODBC

Hello Everyone...
I have a problem creating a very simple database application using ODBC in visual studio 2008..
I started with dialog based application, and add manually a ODBC consumer wizard and i found problem when i checked the "Binding All Column" check box. after pressed OK, visual studio stucked..So restart again and unchecked it..Works

My application are inputting 2 edit controls with integer variables and store it in a database with 1 table 3 fields (ID, X, Y).

Now, ihave this code

CTable1::CTable1(CDatabase* pdb)
    : CRecordset(pdb)
{
    m_var3 = 0;
    m_var4 = 0;
    m_nFields = 3;
    m_nDefaultType = dynaset;
}

and

void CTable1::DoFieldExchange(CFieldExchange* pFX)
{
    pFX->SetFieldType(CFieldExchange::outputColumn);
    RFX_Int(pFX, _T("[X]"), m_var3);
    RFX_Int(pFX, _T("[Y]"), m_var4);

// Macros such as RFX_Text() and RFX_Int() are dependent on the
// type of the member variable, not the type of the field in the database.
// ODBC will try to automatically convert the column value to the requested type
}

and i build it,debug it, and press a DO button...
message box appears "Syntax Error in FROM cause"

How can i find the syntax?
OS Windows 7
Visual Studio 2008