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);
}
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