ÇóÖú access ÎÞȨÏÞ´ò¿ª±í
°²×° SkyÓªÏú¹ÜÀíϵͳ ºó
ÓÐÎļþ Sample.sky , ÎÒ°ÑÕâÎļþ Ð޸ijÉSample.mdb
È»ºóÓÃaccess´ò¿ªSample.mdb £¨ÐèÒªÃÜÂ룩
È»ºó¿ÉÒÔ¿´µ½ËùÓбíµÄÁбíÒ³£¬
µ«ÊÇ´ò¿ª±íÌáʾ£º²»ÄܶÁÈ¡¶¨Ò壻¶Ô±í»ò²éѯ ¡®××ס¯Ã»ÓжÁÈ¡¶¨ÒåȨÏÞ
Çó¸÷λ°ï棡£¡£¡£¡
»¹Óиö System.mdwÎļþ Ó¦¸ÃÊÇ¿ØÖÆÈ¨Ï޵İÉ
²»ÊÇÖ»¶ÁÎļþ£¬
ÄÜÔÚaccess´ò¿ª Sample.mdb µ«ÊÇûÓÐÈκÎȨÏÞ ÈçÓÒ¼ü ¸´ÖÆ¡¢µ¼³ö¡¢É¾³ýµÈµÈ¶¼ÊDz»¿ÉÒ﵀ £¬
ÔÚÏëÊDz»ÊÇ¿ÉÒÔÈà Sample.mdb ºÍ System.mdw È¡Ïû°ó¶¨ »òÕßÓÐû±ðµÄ·½·¨ ÔÚËÑË÷ÄØ
{{
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
¸÷λ¸ßÊֺã¬Âé·³°ïÎÒ¿´ÏÂÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣺
×öÁËÒ»¸öBBSµ«ÊÇÊý¾Ý¿â¾ÍÊÇÁ¬½Ó²»ÉÏ¡£´íÎó´úÂëÈçÏÂ
HTTP Status 500 -
------------------------------------------------------------------------------- ......
ÎÒÊÖ¶¯Ìí¼Ó»ùÓÚCRecordSetÀàµÄÅÉÉúÀàCODBCDemoSetÀà,ÊÇÀûÓÃclass wizardÌí¼ÓµÄ¡£²¢ÇÒ¶¨ÒåÁËÒ»¸öÈ«¾Ö±äÁ¿CODBSDemoSet*m_pCommon.µ«ÊÇÎÒ³ÌÐò²»ÄÜÔËÐС£ÎÒ¸ú×ÙÁËһϣ¬µ½ÁËm_pCommon->Isopen£¨£©´¦·¢Éú´íÎ󣬣 ......