MFC与数据库间的有关问题
MFC与数据库间的问题
CString temp = ("insert into course (cnumber,cname,ctime,ctype,ccredit) values('%s','%s','%s','%s','%s')",m_CNUMBER,m_CNAME,m_CTIME,m_CTYPE,m_CCREDIT);
strSQL.Format(temp);
m_database.ExecuteSQL(strSQL);
可是执行到 第二句的时候 temp取得并不是我想的SQL语句 而是m_CCREDIT的值
怎么办
------解决方案--------------------
strSQL.Format("insert into course (cnumber,cname,ctime,ctype,ccredit) values('%s','%s','%s','%s','%s')",m_CNUMBER,m_CNAME,m_CTIME,m_CTYPE,m_CCREDIT);
CString temp = ("insert into course (cnumber,cname,ctime,ctype,ccredit) values('%s','%s','%s','%s','%s')",m_CNUMBER,m_CNAME,m_CTIME,m_CTYPE,m_CCREDIT);
strSQL.Format(temp);
m_database.ExecuteSQL(strSQL);
可是执行到 第二句的时候 temp取得并不是我想的SQL语句 而是m_CCREDIT的值
怎么办
------解决方案--------------------
strSQL.Format("insert into course (cnumber,cname,ctime,ctype,ccredit) values('%s','%s','%s','%s','%s')",m_CNUMBER,m_CNAME,m_CTIME,m_CTYPE,m_CCREDIT);