Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¼±~~~~!!VC 8.0,ADO ACCESS,¶ÁÈ¡,¸ß·Ö~~!!!!!!

¸÷λ´óÏÀ,ÎÒÓõÄÊÇVC8.0ºÍADOÀ´²Ù×÷access,ÔÚûÓдòVS 2005 SP1µÄʱºò,·¢²¼ÁË,³ÌÐòÔËÐÐÕý³£.

ºóÀ´ÎÒ´òÁËSP1Ö®ºó,ÔÙ·¢²¼,³ÌÐòÿ´ÎÔÚÈ¡³öÊý¾Ý¼¯Ö®ºó,×ÜÊdzö´í(´úÂëûÓи͝).³ö´íÀàËÆÓÚ:

ÎÒselect *,°ÑËùÓÐ×ֶεÄÖµ¶¼È¡³öÀ´,±ÈÈçÓÐ6¸ö×Ö¶Î,Ç°Ãæ4¸ö×ֶζ¼ºÜÕý³£,µÈµ½µÚ5¸ö,µÚÁù¸öʱºò³ö´í,»¹²¢²»ÊÇÔÚGetCollectʱºò,¶øÊǽ«Öµ×ª»»³É×Ö·û´®µÄʱºò,ÎÒÒ²¼ÓÁËÅжÏVT!=NULL,¿ÉÊdzÌÐò»¹ÊDZÀÀ£.
ÎÒÊÇÖ±½ÓתµÄ±ÈÈç:CString strResult=(char *)_bstr_t(varResult);°üÀ¨ÆäËûµÄת»»¶¼ÊÔ¹ý,»¹ÊDZÀÀ£.

ÕâÒ»Çж¼ÊÇÔÚûÓдòSP1µÄʱºòËùûÓз¢ÉúµÄ.

´òÍêSP1¸Ã³ÌÐòÔÚ±¾»úÔËÐÐÕý³£,µ«ÊÇÒ»µ©·¢µ½ÆäËû»úÆ÷ÉϾͱÀÀ£.

ÏëÇë½Ì¸÷λ´óÏÀ,ÔõÑù½â¾ö???

лл,лл


»¹ÊÇÔÚͬһ¸öµØ·½±ÀÀ£,²»Ðа¡


²¶»ñ²»µ½Òì³£

´úÂëÀàËÆÓÚ
CString strResult;
try
{
  strResult=(char *)_bstr_t(varResult);
}
catch(_com_error &e)
{
....
}
¸ù±¾½ø²»ÁËcatch,Ö±½ÓÔÚstrResult=(char *)_bstr_t(varResult);Õâ¸öÓï¾ä¾Í±ÀÀ£ÁË

strResult=(char *)_bstr_t(varResult);Õâ¾äûÓÐʲôÎÊÌâ°¡¡£¡£

ÓÐʲôÎÊÌâÄØ?


catch(...)Ò²²»ÐÐ

µ«ÊÇÔÚ±¾»ú¾ÍÔËÐеĺܺÃ,ÆäËû»úÆ÷¾Í²»ÐÐ


Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......

ÈçºÎÔÚVB.NET´´½¨accessÊý¾Ý¿â£¿

¸Õ¸Õ½Ó´¥VB.NET£¬¶Ô.NET»ù±¾Ê²Ã´Ò²²»¶®£¬Çë¸ßÊÖ¸øÒ»¶Î½ÏÍêÕû´´½¨accessÊý¾Ý¿âµÄʾÀý´úÂ룬ÈÃÎÒѧϰһÏ¡£
Ëùν½ÏÍêÕû´´½¨Êý¾Ý¿âʱ¶¨Òå¸÷¸ö×Ö¶ÎÀàÐ͵ıíʾ·½·¨£¬ÈçÕûÊýÐÍ£¬¸¡µãÐÍ£¬×Ö·ûÐÍ£¨¶¨Ò峤¶ÈÈçºÎ±íʾ£©¡£Ð»Ð» ......

phpÁ¬½ÓaccessÊý¾Ý¿âʱ³ö´í

$conn = @new COM("ADODB.Connection") or die ("ADOÁ¬½Óʧ°Ü!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("database.mdb");
$conn-&g ......

Ò»¸öaccessÊý¾Ý¿âÎÊÌâ¡£ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÏë±£Áô±íÖÐ×îеÄ30¸öÊý¾Ý£¨ÓмǼʱ¼äµÄ×Ö¶Îaddtime£©£¬ÆäÓàµÄɾ³ý£¬ÇëÎÊsqlÓï¾äÔõÑùÐ´ÄØ£¿Ð»Ð»¡£


End_rbody_64466527//-->
¸Ã»Ø¸´ÓÚ2010-04-27 08:37:30±»°æÖ÷ɾ³ý


¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[ ......

ACCESSÈ¥³ýÖØ¸´Öµ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ