ADOX+access Ìí¼ÓÁеÄÎÊÌâ

ÎÒÔÚʹÓÃadox+access,ʹÓóÌÐòÌí¼ÓÐÂÁеÄʱºò×ÜÊdzöÏÖ´íÎó,¶¼ÓÐÄÄЩÐèҪעÒâµÄѽ,лл!

ÎҵĴúÂëÊÇÕâÑùµÄ!
C/C++ code:

CoInitialize (NULL);
bsSQL = ...(Êý¾Ý¿âÁ¬½Ó×Ö·û´®)
m_pConnection.CreateInstance(__uuidof(Connection));
m_pCommand.CreateInstance(__uuidof(Command));
m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pConnection->Open(bsSQL,"","",adModeUnknown);
m_pCommand->ActiveConnection = m_pConnection;

csSQL.Format (_T("alter table pd add COLUMN %s int"),strColumnsName);
m_pConnection->Execute ((_bstr_t)csSQL,NULL,adCmdText);





²»ÖªµÀÊÇÄÄÀï´íÁË,Ï£Íû´ó´óÃÇÖ¸µã,лл!

---

COLUMN %s int"),---->
COLUMN %s integer"),

---

ÎÒµÄËùÓеÄsqlÓï¾ä,µ¥¶ÀµÄÔÙÊý¾Ý¿âÉÏÖ´ÐеÄʱºò¶¼ÕýÈ·,µ«ÊÇ,һʹÓÃADOXÖ´ÐеÄʱºò,¾Í»á³ö´í,
Ó¦¸ÃÊÇadoxµÄijЩÃüÁî»òÕßÉèÖóöÎÊÌâÁË°É!

COLUMN %s int"),---->
COLUMN %s integer"),
ÊÔ¹ýÁË,»¹ÊDz»¶Ô!

ллfeilinhe´ó´ó!

---

COLUMN %s integer default 0")ÄØ

---

Ò²ÊÔ¹ýÁË,²»ÐÐ!

---

¿´¿´Á¬½ÓµÄ´ò¿ª·½Ê½

---

ÒýÓÃ

try
{
  m_pConnection->Execute ((_bstr_t)csSQL,NULL,adCmdText);
}
catch(_com_error e)
{
  MessageBox(