ACCESS½¨±íÎÊÌâ

m_pConnect->BeginTrans();
strSql.Format("CREATE TABLE SysUser(lsh AUTOINCREMENT NOT NULL UNIQUE,PRIMARY KEY(lsh),userType BYTE)");
m_pConnect->Execute((_bstr_t)strSql,NULL, adExecuteNoRecords);
ÕâÑù½¨±í¾Í³É¹¦£¬
°ÑsqlÓï¾ä»»³É
strSql.Format("CREATE TABLE SysUser(lsh AUTOINCREMENT NOT NULL UNIQUE,PRIMARY KEY(lsh),UserID VARCHAR(50),UserName VARCHAR(50),Password VARCHAR(50),userType BYTE)");
m_pConnect->Execute((_bstr_t)strSql,NULL, adExecuteNoRecords);Ö´ÐоʹíÎóÁË ¡£¡£¡£
ÓôÃÆËÀÁË¡£

---

SQL code:
'AccessÖÐûÓÐvarcharÀàÐÍ£¬ÓÃTEXTÀàÐÍ´úÌæ¡£
CREATE TABLE SysUser(lsh AUTOINCREMENT NOT NULL UNIQUE,PRIMARY KEY(lsh),UserID TEXT,UserName TEXT,Password TEXT,userType BYTE

---

µ«ÊÇÄǸöÓï¾äÔÚaccessµÄ²éѯ£ºÊý×Ö¶¨Òå²éѯÀïÃæÊÇ¿ÉÒԳɹ¦´´½¨µÄ¡£

---

°ÑVARCHAR»»³ÉTEXTÒ²ÊÇͬÑùµÄ´íÎ󣬵±Óöµ½´íÎóʱ³ÌÐòÔËÐеÀ
inline _RecordsetPtr Connection15::Execute ( _bstr_t CommandText, VARIANT * RecordsAffected, long Options ) {
    struct _Recordset * _result = 0;
    HRESULT _hr = raw_Execute(CommandText, RecordsAffected, Options, &_result);
    if (FAILED(_hr)) _com_issue_errorex(_hr, this, __uuidof(this));
    return _RecordsetPtr(_result, false);
}----------------------------------------------------------------msado1