sqliteÊý¾Ý¿â²»ÄÜÁ¬Ðø´æÈëÊý¾ÝµÄÎÊÌâ

ÎÒÓÃevc±àдµÄ³ÌÐò£¬½«¶Ô»°¿òÖеÄÊý¾Ý´æÈëÊý¾Ý¿â£¬µÚÒ»´Î¿ÉÒÔ´æÈ룬²»¹ýµÚ¶þ´ÎÊäÈëµÄÊý¾Ý²»ÄÜ´æÈëµ½Êý¾Ý¿âÖС£
ÏÂÃæÊÇÎҵijÌÐò
UpdateData(TRUE); // TODO: Add your control notification handler code here
if (!CheckVaild())//¼ì²éÊäÈëÐÅÏ¢ÊÇ·ñÍêÕû
{
AfxMessageBox(L"ÊäÈëÐÅÏ¢²»ÍêÕû!");
return;
}
int result;
CString str;
char *sql="INSERT INTO\"faultcode\" VALUES(NULL,'a','a','a','a'); ";
str="INSERT INTO faultcode  VALUES(NULL,'";
    str+=m_Snumber;
    str+="','";
    str+=m_Sname;
    str+="','";
    str+=m_Sreason;
    str+="','";
    str+=m_Sstep;
    str+="');";

memset(sql, 0,100);
WideCharToMultiByte(CP_ACP, 0, str, -1, sql, 100, NULL, NULL);
str=sql;             
RETAILMSG(1, (TEXT("%s \n\r\n"),str));
result=sqlite3_exec( db , sql , 0 , 0 , &zErrMsg);
if(result !=SQLITE_OK)
printf("zErrMsg = %s \n", zErrMsg);

m_Snumber = _T("");
m_Sname = _T("");
m_Sreason = _T("");
m_Sstep = _T("");
UpdateData(FALSE);

AfxMe