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(
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý" ²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!! ´ó¼Ò¶¼ ......
ÈçºÎÔÚvcÖÐʹÓÃADOXΪaccessÊý¾Ý¿âÌí¼ÓÒ»¸öÓû§? лл! ßí?ÔõôûÈËÀ´¿´¿´Ñ½? ÎÒŪ ÁË ºÃ¾ÃÁË,¶¼Ã»Ò»µãÍ·Ð÷! ÄÇλ´ó´óÀ´¾È¾È¼±Ñ½! ллÁË! Ìí¼ÓÒ»¸öÓû§ÊÇʲôÒâ˼£¿£¿Ìí¼ÓÒ»ÕÅ±í£¿£¿»¹ÊÇ´´½¨Ò» ......
select * from ±íÃû ±íÀïÓÐ100ÌõÊý¾Ý£¬¿ÉÊÇÖ»²éѯ³öǰ90Ìõ£¬ÆäÓàµÄ²»ÏÔʾ¡£ÒªÊǸù¾ÝID²éѯ£¬ÆäÓàµÄÒ²¿ÉÒԲ鵽¡£ ÕâÊÇʲôÎÊÌâ°¡£¿ ѹËõMDBÊÔÊÔ¡¡OR¡¡Ð½¨Ò»¸öMDB£¬µ¼Èë¾É±íÊý¾Ý£¬ÔÙ²éѯÊÔÊÔ ÉÏ´«ÄãµÄ± ......
ÎÒÓà ado ·ÃÎÊaccess¿âʱ Óà select * from user_info where user_id=ÕÅÈý ¾Í³ö´í£¬Èç¹ûÈ¥µô where user_id £¬Ö»ÊÇselect * from user_info¾ÍûÎÊÌâ Ϊʲô²»ÄܼÒÑ¡ÔñÄØ °ï°ïæ½â´ðһϠлл select * from user_in ......