CString strSQL; TRY
{
strSQL = "DROP TABLE consumer";
m_database.ExecuteSQL(strSQL);
}
CATCH(CDBException,e)
{ }
END_CATCH
strSQL ="CREATE TABLE consumer(";
CString str;
str="";
AddCol(str,"account char(20) NOT NULL");
AddCol(str,"name char(15) NOT NULL");
AddCol(str,"accounttype tinyint NOT NULL");
AddCol(str,"deput char(15)");
AddCol(str,"sealcount tinyint");
AddCol(str,"create_date datetime NOT NULL");
AddCol(str,"begindate datetime NOT NULL");
AddCol(str,"depart_id char(10) NOT NULL");
AddCol(str,"telephone char(20)");
AddCol(str,"address char(50)");
AddCol(str,"state tinyint NOT NULL");
strSQL +=str; strSQL +=')'; TRY
{
m_database.ExecuteSQL(strSQL);
}
CATCH(CDBException,e)
{
m_wPrompt="数据库表Consumer表建立失败!";
UpdateData(FALSE);
return FALSE;
}
END_CATCH
strSQL = "ALTER TABLE consumer ADD CONSTRAINT PK_accounts PRIMARY KEY CLUSTERED(account)";
TRY
{
m_database.ExecuteSQL(strSQL);
}
CATCH(CDBException,e)
{
m_wPrompt="数据库表Consumer表主键建立失败!";
UpdateData(FALSE);
return FALSE;
}
{
strSQL = "DROP TABLE consumer";
m_database.ExecuteSQL(strSQL);
}
CATCH(CDBException,e)
{ }
END_CATCH
strSQL ="CREATE TABLE consumer(";
CString str;
str="";
AddCol(str,"account char(20) NOT NULL");
AddCol(str,"name char(15) NOT NULL");
AddCol(str,"accounttype tinyint NOT NULL");
AddCol(str,"deput char(15)");
AddCol(str,"sealcount tinyint");
AddCol(str,"create_date datetime NOT NULL");
AddCol(str,"begindate datetime NOT NULL");
AddCol(str,"depart_id char(10) NOT NULL");
AddCol(str,"telephone char(20)");
AddCol(str,"address char(50)");
AddCol(str,"state tinyint NOT NULL");
strSQL +=str; strSQL +=')'; TRY
{
m_database.ExecuteSQL(strSQL);
}
CATCH(CDBException,e)
{
m_wPrompt="数据库表Consumer表建立失败!";
UpdateData(FALSE);
return FALSE;
}
END_CATCH
strSQL = "ALTER TABLE consumer ADD CONSTRAINT PK_accounts PRIMARY KEY CLUSTERED(account)";
TRY
{
m_database.ExecuteSQL(strSQL);
}
CATCH(CDBException,e)
{
m_wPrompt="数据库表Consumer表主键建立失败!";
UpdateData(FALSE);
return FALSE;
}
db.Create("c:\\vod.mdb");