sql
-
When ruuning my exe, i am getting a 'syntax error in my SQL statemnt'. Here is the code form where the error is coming?? void CMgen1View::LoadListbox() { CMgen1Doc* pDoc = GetDocument(); CListBox* pLB = (CListBox*) GetDlgItem(IDC_LIST1); CMgen1Set sect(&pDoc->m_database); sect.m_strFilter = "InstructorID = '366'"; sect.Open(NULL, _T( "Select * from Section WHERE sect.m_strFilter" )); pLB->ResetContent(); while(!sect.IsEOF()) { CString str; str.Format(_T("%d %d"),sect.m_CourseID , sect.m_SectionNo); pLB->AddString(str); } }
-
When ruuning my exe, i am getting a 'syntax error in my SQL statemnt'. Here is the code form where the error is coming?? void CMgen1View::LoadListbox() { CMgen1Doc* pDoc = GetDocument(); CListBox* pLB = (CListBox*) GetDlgItem(IDC_LIST1); CMgen1Set sect(&pDoc->m_database); sect.m_strFilter = "InstructorID = '366'"; sect.Open(NULL, _T( "Select * from Section WHERE sect.m_strFilter" )); pLB->ResetContent(); while(!sect.IsEOF()) { CString str; str.Format(_T("%d %d"),sect.m_CourseID , sect.m_SectionNo); pLB->AddString(str); } }
The problem is in your sql statement "Select * from Section WHERE sect.m_strFilter" The SQL server doesn't know what sect.m_strFilter means. Try Select * from Section WHERE InstructorID = '366'
-
When ruuning my exe, i am getting a 'syntax error in my SQL statemnt'. Here is the code form where the error is coming?? void CMgen1View::LoadListbox() { CMgen1Doc* pDoc = GetDocument(); CListBox* pLB = (CListBox*) GetDlgItem(IDC_LIST1); CMgen1Set sect(&pDoc->m_database); sect.m_strFilter = "InstructorID = '366'"; sect.Open(NULL, _T( "Select * from Section WHERE sect.m_strFilter" )); pLB->ResetContent(); while(!sect.IsEOF()) { CString str; str.Format(_T("%d %d"),sect.m_CourseID , sect.m_SectionNo); pLB->AddString(str); } }
Replace sect.Open(NULL, _T( "Select * from Section WHERE sect.m_strFilter" )); With sect.Open(NULL, _T(CString("Select * from Section WHERE ") + sect.m_strFilter ));