我在建数据库时选了一张表book,现在相对表student进行更新,不知下面的语句有什么错误,系统提示说语法错误,各位大哥帮帮小弟吧,多谢了
CDatabase db;
db.Open( _T("ODBC;DSN=data"));
CString s;
//s=_T("");
s=_T("insert into [student] (stu_id,stu_name,address,phone_number) values('");
s+=_T(m_student_id);
s+=_T("','");
s+=_T(m_student_name);
s+=_T("','");
s+=_T(m_address);
s+=_T("','");
s+=_T(m_phone);
s+=_T("')"); db.ExecuteSQL(s);
db.Close();
CDatabase db;
db.Open( _T("ODBC;DSN=data"));
CString s;
//s=_T("");
s=_T("insert into [student] (stu_id,stu_name,address,phone_number) values('");
s+=_T(m_student_id);
s+=_T("','");
s+=_T(m_student_name);
s+=_T("','");
s+=_T(m_address);
s+=_T("','");
s+=_T(m_phone);
s+=_T("')"); db.ExecuteSQL(s);
db.Close();
试试
db.Open( _T("ODBC;DSN='data'"));
2、是不是stu_id的类型和数据库中对应的类型(int)不对?
建议你将双引号中的字符串‘,’分开写试一下。