¼±~~~~!!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(...)Ò²²»ÐÐ
µ«ÊÇÔÚ±¾»ú¾ÍÔËÐеĺܺÃ,ÆäËû»úÆ÷¾Í²»ÐÐ
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨ ......
ACCESSÖвéѯÈçÏ£º
PARAMETERS letter Text ( 255 );
SELECT ¡¡¡¡ from table1 WHERE letter = letter
ÎÒ¿´µ½¹ý´«µÝÁ½¸ö²ÎÊý£¨Ê±¼ä£©µÄÀý×Ó¡£ÒòΪСµÜÊǰ®ºÃ£¬²»ÊÇרҵ³ÌÐòÔ±£¬ËùÒÔ²»ÖªµÀÔõ ......
oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......