测试ExecuteSQL()函数~ 只要SQLCE语句正确那么就返回TRUE

1. CStringcsSql3=_T("SELECT*FROMUserTbWHEREuid=123456;");
2. wicDB.ExecuteSQL(csSql3);
4. if(wicDB.OpenRecordset(csSql3,1))
5. {
6. CStringstrPar=_T("privilege");
7. result3=wicDB.GetCollect(strPar);
8. MessageBox(NULL,result3.bstrVal,_T("PASS"),MB_OK);
9. }

1. csSql=_T("SELECT*FROMUserTbWHEREuid='1234';");
3. if(wicDB.ExecuteSQL(csSql))
4. {
5. MessageBox(NULL,csSql,_T("PASS"),MB_OK);
6. }
8. csSql=_T("SELECT*FROMUserTbWHEREuid='123';");
10. if(wicDB.ExecuteSQL(csSql))
11. {
12. MessageBox(NULL,csSql,_T("PASS"),MB_OK);
13. }
14. else
15. {
16. MessageBox(NULL,csSql,_T("FAIL"),MB_OK);
17. }
19. csSql=_T("SELECT*FROMUserTbWHEREuid='123456';");
21. if(wicDB.ExecuteSQL(csSql))
22. {
23. MessageBox(NULL,csSql,_T("PASS"),MB_OK);
24. }
25. 以下的代码是完全OK的~
    
26. 1. CDBManagewicDB;
    3. wicDB.OpenDB();//连接数据库
    5. //打开记录集
    6. CStringSqlStr=_T("SELECT*FROMUserTbWHEREuid='123456'");
    7. if(wicDB.OpenRecordset(SqlStr,1))
    8. {
    9. MessageBox(NULL,_T("OpenOK"),_T("OpenRecordset"),MB_OK);
    11. }
    12. else
    13. {
    14. MessageBox(NULL,_T("OpenFail"),_T("OpenRecordset"),MB_OK);
    15. }
    17. VARIANTvPwd;
    18. VariantInit(&vPwd);
    20. CStringstrParam=_T("privilege");
    22. vPwd=wicDB.GetCollect(strParam);
    24. MessageBox(NULL,vPwd.bstrVal,_T("OpenRecordset"),MB_OK);
    26. wicDB.CloseDB();
    28. returnTRUE;
    1. CStringtest1=_T("TestUPC1"),test2=_T("1234567");
    3. wicDB.SetItemPrice(test1,test2);
    4. 测试SetItemPrice函数
    1. LastTransaction*ltExample;
    2. if(wicDB.GetLastTransData(ltExample))
    3. {
    4. ;
    5. }
    1. LastTransactionltExample={"004","4","40","123","08102","11111","08102011111"};
    2. //在初始化的时候注意字符初始化的时候大小问题
       
    3. if(wicDB.SetLastTransData(ltExample))
    4. {
    5. ;
    6. }