ÈçºÎ¶ÁÈ¡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
ÎÒ²»¶®Êý¾Ý¿â
½áÌùÌáÐÑ
Èç¹ûÄúµÄÎÊÌâÒѾµÃµ½½â¾ö£¬ÇëÄúÔçÈÕ½áÌù£¬ÈçËÄÈÕºóδ½áÌù£¬¸ÃÌù½«×öÇ¿ÖÆ½áÌù´¦Àí¡£
Èç¹ûÄúµÄÎÊÌâÉÐδµÃµ½½â¾ö£¬Çë»Ø¸´·½±ãÆäËûÍøÓÑÖªµÀÄãÈÔ¹Ø×¢¸ÃÎÊÌâ¡£ÈçËÄÈÕºóûÓÐÆäËûÍøÓѺÍÂ¥Ö÷±¾È˻ظ´£¬¸ÃÌù½«×öÇ¿ÖÆ½áÌù´¦Àí¡£
Èç¹ûÌù×ÓÖ»ÓÐÂ¥Ö÷ºÍÇ¿ÖÆ½áÌùµÄ°æÖ÷±¾È˻ظ´£¬½«°´ÎÞÂúÒâ½áÌû´¦Àí¡£
×¢£ºÇ¿ÖƽáÌù°æÖ÷±¾È˽«²»»á·ÖÅä´ðÌâ·Ö
Ïà¹ØÎÊ´ð£º
¸÷λ¸ßÊֺã¬Âé·³°ïÎÒ¿´ÏÂÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣺
×öÁËÒ»¸öBBSµ«ÊÇÊý¾Ý¿â¾ÍÊÇÁ¬½Ó²»ÉÏ¡£´íÎó´úÂëÈçÏÂ
HTTP Status 500 -
------------------------------------------------------------------------------- ......
oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......
ÏÂÃæÊÇÊý¾Ý
ID Money PID
1 50
2 40 1
3 30 1
4 ......
±íd_fy
×ֶΣºd_id(×Ô¶¯±àºÅ)£¬ d_je£¨»õ±ÒÐÍ£©,d_sxrq£¨ÈÕÆÚÐÍ£©
±íÊý¾ÝÈçÏ£º
d_id d_je d_sxrq
1 20 2009-5-1
2 30 2009-5-6
3 10 2009-6-5
4 15 2009-6-25
......
ÓÃAccessÊý¾Ý¿â×öµÄÍøÕ¾£¬connectionString д³É¡°Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\SeaHorse\\Web\AccessDB\\seaHorse.mdbPersist Security Info=True" ¾ÖÓòÍø·¢²¼Ã»ÓÐÎÊÌ⣬ÇëÎÊ·¢²¼µ½Inter ......