VCµÄADO²Ù×÷AccessÊý¾Ý¿âµÄÎÊÌâ - VC/MFC / »ù´¡Àà
´ó¼Ò°ïæһÏÂADOÁ¬½ÓÉÏÁËÊý¾Ý¿â£¬µ«ÊÇÎÒ²Ù×÷µÄʱºò¾Í»á´íÎ󣬲»ÖªµÀΪʲô£¬±ÈÈçÎÒÉùÃ÷ÁË
_RecordsetPt m_pRecordset;À´²Ù×÷m_pRecordset->adoEOF¾Í»á³ö´í£¬²»ÖªµÀΪʲô£¬Ö»ÒªÓõ½m_pRecordsetÕâ¸öÖ¸Õë¾Í»áµ¯
³ö£ºRuntime Error!
Program:...
This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
Èç¹ûÎҰѹØÓÚm_pRecordsetµÄ¶«Î÷×¢Ê͵ô¾Í¿ÉÒÔÁË£¬²»ÖªµÀΪʲô£¬ÇëÄãÃǰïæÒÔÏ£¬
ÎÒŪÁ˼¸Ì죬ԴÂëÒ²¿´Á˺ܶ൫ÊÇ»¹ÊDz»¶®£¬È˼ÒÔ´Âë¿ÉÒÔµ«ÊÇÎÒ×öµÄʱºò¾Í»á³ö´í£¡
ÏȸÐл´ó¼Ò£¡
m_pRecordsetÕâ¸öÄãû³õʼ»¯¾ÍÄÃÀ´ÓÃ.....
ÎÒ¸ÕдÁËÒ»¸ö²©¿Í
¿´¿´»á²»»á¶ÔÄãÓаïÖú
http://blog.csdn.net/xianglitian/archive/2010/05/22/5617173.aspx
¼ÓÉÏÕâÒ»¾ä m_pRecordset.CreateInstance(__uuidof(Recordset));ÓÃÀ´³õʼ»¯m_pRecordset
ËÆºõÎÒ¼ÓÁ˲»¿ÉÒ﵀ £¬²»ÖªµÀΪʲô = = ¡¢Ë»á°ïÎÒŪ¸öÏêϸµãµÄ½Ì³Ì
¿´¿´Õâ¸öÌû×Ó
http://http://topic.csdn.net/u/20100429/11/a1a68cd2-d942-4f6b-b387-69a130ec5888.html
ÄãÊÔÊÔm_pRecordset->EOFÕâ¸öÓдíÂð£¿
Êý¾ÝÔ´¸Ä³É¾ø¶Ô·¾¶ÊÔÊÔ¡£ÎÒÕýºÃÔÚѧ£¬ÕâÊÇÎҵģº
class CADODB
{
public:
CADODB();
virtual ~CADODB();
public:
_RecordsetPtr m_pRecordset;
void OnInitADODB(_bstr_t strConnect,_bstr_t userID,_bstr_t password);
void Select(_bstr_t sqlstr);
void Execute(_bstr_t sqlstr);
void AddNew(_
Ïà¹ØÎÊ´ð£º
ÒÑÖªAccessÊý¾Ý¿â a.mdb´æÔÚÒ»¸ö±í£ºcc£¬¼ÙÈçccµÄ±í½á¹¹ÈçÏ£º
×Ö¶ÎÃû³Æ Êý¾ÝÀàÐÍ ËµÃ÷
tName Îı¾ Ö¸¶¨ÈËÔ±µÄÐÕÃû
tAge Êý×Ö ......
ÎÒÏë´ÓAccess µ¼³öÊý¾Ýµ½DB2£¬ ±ÈÈç˵Access±íÖÐÓÐ3ÌõÊý¾Ý£¬ÎÒÒªµ¼ÈëDB2£¬²¢ÇÒҪɾ³ý¡£ µ«ÊDzåÈë3ÐпÉÒԳɹ¦£¬É¾³ýÖ»ÄÜɾ³ý1ÐУ¬²¢ÇÒµÚÒ»ÐÐɾ³ý3±é£¨ÒòΪÓÐ3ÌõÊý¾Ý£©¡£ ´úÂëÈçÏ£º¿ÒÇë¸÷λ¸ßÊÖÖ¸µãÒ»¶þ£¬Ð¡µÜ¸Ð¼¤²»¾ ......
´úÂëÕâôдµÄ
string sqlCmd = "SELECT * INTO [;Data Source=D:\\2010-05-20.mdb,pwd=].main from RptMain WHERE RptCode in " + queryrms;
int i = rmdc.ExecuteCommand(sqlCmd);
È»ºóÌáʾ´íÎó
Ö¸¶ ......
create view ±íÃû
as
select a.a1,b.b1 from a inner join b on a.id=b.id
Õâ¸öÓï·¨ÔõôдÉÏÈ¥ÊÇ´íµÄÔÚAccessÀï
ACCESSºÃÏñ²»Ö§³Öcreate view
Äã¿ÉÒÔÔÚACCESSÖе¥»÷¡°ÊÓͼ¡±²Ëµ¥£¬Ñ¡Ôñ¡°SQLÊÓͼ¡±ÃüÁ ......
using(OleDbConnection conn = new OleDbConnection(Properties.Settings.Default.urlRecordConnectionString))
{
try
{
......