ÈçºÎ¶ÁÈ¡Access±íµÄ×Ö¶Î˵Ã÷ - VC/MFC / Êý¾Ý¿â
ÒÑÖªAccessÊý¾Ý¿â a.mdb´æÔÚÒ»¸ö±í£ºcc£¬¼ÙÈçccµÄ±í½á¹¹ÈçÏ£º
×Ö¶ÎÃû³Æ Êý¾ÝÀàÐÍ ËµÃ÷
tName Îı¾ Ö¸¶¨ÈËÔ±µÄÐÕÃû
tAge Êý×Ö Ö¸¶¨ÈËÔ±µÄÄêÁä
tSex Îı¾ ÐÔ±ð
ÏÖÔÚµÄÎÊÌâÊÇ£º
ÎÒÒѾȡµ½Á˱íµÄ¸÷¸ö×Ö¶ÎÃû³Æ£¬tName,tAge,tSex£»
ͨ¹ýÏÂÊö´úÂë¿ÉÒÔÈ¡µ½¸÷¸ö×ֶζÔÓ¦µÄÊý¾ÝÀàÐÍ
int l_iType = m_RecordsetTable->Fields->GetItem((_variant_t)str)->Type;
µ«ÊÇÎÒ²»ÖªµÀÈçºÎÈ¡µ½Ã¿¸ö×ֶζÔÓ¦µÄ˵Ã÷ÄØ£¿Çë¸ßÊÖ½â´ð£¬¶àл¶àл£¡
ÎÒÒ²ÏëÖªµÀ
¿´ÁËÏÂûÕÒµ½£¬ÕÒµ½¸öadoxµÄ¡£
http://support.microsoft.com/kb/210314/zh-cn
End_rbody_65632130//-->
¸Ã»Ø¸´ÓÚ2010-06-10 20:14:48±»°æÖ÷ɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
soswaidao
(¡ïÍáµÁ¡ï)
µÈ¡¡¼¶£º
#4Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2010-05-22 09:16:55
ÎÒ²»¶®Êý¾Ý¿â
½áÌùÌáÐÑ
Èç¹ûÄúµÄÎÊÌâÒѾµÃµ½½â¾ö£¬ÇëÄúÔçÈÕ½áÌù£¬ÈçËÄÈÕºóδ½áÌù£¬¸ÃÌù½«×öÇ¿ÖÆ½áÌù´¦Àí¡£
Èç¹ûÄúµÄÎÊÌâÉÐδµÃµ½½â¾ö£¬Çë»Ø¸´·½±ãÆäËûÍøÓÑÖªµÀÄãÈÔ¹Ø×¢¸ÃÎÊÌâ¡£ÈçËÄÈÕºóûÓÐÆäËûÍøÓѺÍÂ¥Ö÷±¾È˻ظ´£¬¸ÃÌù½«×öÇ¿ÖÆ½áÌù´¦Àí¡£
Èç¹ûÌù×ÓÖ»ÓÐÂ¥Ö÷ºÍÇ¿ÖÆ½áÌùµÄ°æÖ÷±¾È˻ظ´£¬½«°´ÎÞÂúÒâ½áÌû´¦Àí¡£
×¢£ºÇ¿ÖƽáÌù°æÖ÷±¾È˽«²»»á·ÖÅä´ðÌâ·Ö
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......
accessº¯ÊýºÍopenº¯ÊýµÄÇø±ð
60 if(access(path,R_OK)==0)
61 printf("access read success \n");
62 else
63 printf("access read er ......
ÎÊÌâÈçÏÂ:
ÔÚÍøÒ³ÖÐÐÞ¸ÄÊý¾Ýºó,ACCESSÊý¾Ý¿âÖжÔÓ¦µÄÊý¾Ý±íÖÐȴûÓÐдÈëÐ޸ĺóµÄÊý¾Ý;
È»¶øÔÚÍøÒ³Öвéѯ¸ÕÐ޸ĵÄÊý¾Ý,È´¿ÉÒÔÏÔʾ³öÐ޸ĺóµÄÊý¾Ý.
¸Õ½Ó´¥µ½ASP,Çë¸÷λ´ïÈËÖ¸½Ì!
¿Ï¶¨ÊÇÊý ......
Ë»ávb+accessͼÊé¹ÜÀíϵͳ±ÏÒµÉè¼Æ°¡£¿»áµÄ»°¿É²»¿ÉÒÔ°ïÒ»ÏÂæ£¿
¸Ð¼¤²»¾¡ÁË¡£¡£¡£
lzÓÐûÓÐÇ®°¡£¿Óеϰ¿É²»¿ÉÒÔ¸øÒ»Ð©Ñ½£¿
¸Ð¼¤²»¾¡ÁË¡£¡£¡£
ÎÒÓУ¬ÎÒÉÏ´«ÊÔÊÔ
¿É²»¿ÉÒÔ·¢µ½ÎÒÓÊÏä°¡£¿youchen.emi@gmail ......