ÀúÊ·ÇúÏ߿ؼþʹÓ÷½·¨
KVHTrend¿Ø¼þʹÓ÷½·¨
KVHTrendÇúÏ߿ؼþÊÇ×é̬ÍõÒÔActive X¿Ø¼þÐÎʽÌṩµÄ»æÖÆÀúÊ·ÇúÏߺÍODBCÊý¾Ý¿âÇúÏߵŦÄÜÐÔ¹¤¾ß¡£Í¨¹ý¸Ã¿Ø¼þ£¬²»µ«¿ÉÒÔʵÏÖÀúÊ·ÇúÏߵĻæÖÆ£¬»¹¿ÉÒÔʵÏÖODBCÊý¾Ý¿âÖÐÊý¾Ý¼Ç¼µÄÇúÏß»æÖÆ£¬¶øÇÒÔÚÔËÐÐ״̬Ï£¬¿ÉÒÔʵÏÖÔÚÏß¶¯Ì¬Ôö¼Ó/ɾ³ýÇúÏß¡¢ÇúÏßͼ±íµÄÎÞ¼¶Ëõ·Å¡¢ÇúÏߵĶ¯Ì¬±È½Ï¡¢.ÇúÏߵĴòÓ¡µÈ¡£¸ÃÇúÏ߿ؼþ×î¶à¿ÉÒÔ»æÖÆ16ÌõÇúÏß¡£
1¡¢´´½¨ÀúÊ·ÇúÏ߿ؼþ£º
ÔÚ×é̬Íõ¿ª·¢ÏµÍ³ÖÐн¨»Ã棬ÔÚ¹¤¾ßÏäÖе¥»÷¡°²åÈëͨÓÿؼþ¡±»òÑ¡Ôñ²Ëµ¥¡°±à¼¡±
ϵġ°²åÈëͨÓÿؼþ¡±ÃüÁµ¯³ö¡°²åÈë¿Ø¼þ¡±¶Ô»°¿ò£¬ÔÚÁбíÖÐÑ¡Ôñ¡°ÀúÊ·Ç÷ÊÆÇúÏß¡±£¬µ¥»÷¡°È·¶¨¡±°´Å¥£¬¶Ô»°¿ò×Ô¶¯Ïûʧ£¬Êó±ê¼ýÍ·±äΪС¡°Ê®¡±×ÖÐÍ£¬ÔÚ»ÃæÉÏÑ¡Ôñ¿Ø¼þµÄ×óÉϽǣ¬°´ÏÂÊó±ê×ó¼ü²¢Í϶¯£¬»ÃæÉÏÏÔʾ³öÒ»¸öÐéÏߵľØÐοò£¬¸Ã¾ØÐοòΪ´´½¨ºóµÄÇúÏßµÄÍâ¿ò¡£µ±´ïµ½ËùÐè´óСʱ£¬ËÉ¿ªÊó±ê×ó¼ü£¬ÔòÀúÊ·ÇúÏ߿ؼþ´´½¨³É¹¦£¬»ÃæÉÏÏÔʾ³ö¸ÃÇúÏߣ¬Èçͼ1Ëùʾ¡£
ͼ1 ÀúÊ·ÇúÏ߿ؼþ
2¡¢ÉèÖÿؼþ¹ÌÓÐÊôÐÔ£º
¿Ø¼þ´´½¨Íê³Éºó£¬ÔڿؼþÉϵ¥»÷ÓÒ¼ü£¬ÔÚµ¯³öµÄ¿ì½Ý²Ëµ¥ÖÐÑ¡Ôñ¡°¿Ø¼þÊôÐÔ¡±ÃüÁµ¯³öÀúÊ·ÇúÏ߿ؼþµÄ¹ÌÓÐÊôÐÔ¶Ô»°¿ò£¬Èçͼ2Ëùʾ¡£
±±¾©ÑǿؿƼ¼·¢Õ¹ÓÐÏÞ¹«Ë¾
ÀúÊ·ÇúÏ߿ؼþʹÓ÷½·¨
¿Ø¼þ¹ÌÓÐÊôÐÔº¬ÓÐÁ½¸öÊôÐÔÒ³£ºÇúÏß¡¢×ø±êϵ¡£ÏÂÃæÏêϸ½éÉÜÿ¸öÊôÐÔÒ³Öеĺ¬Òå¡£
2¡¢1 ÇúÏßÊôÐÔÒ³
Èçͼ2Ëùʾ£¬ÇúÏßÊôÐÔÒ³ÖÐϰ벿·ÖΪ¶¨ÒåÔÚ»æÖÆÇúÏßʱ£¬ÀúÊ·Êý¾ÝµÄÀ´Ô´£¬¿ÉÒÔÑ¡Ôñ×é̬ÍõµÄÀúÊ·Êý¾Ý¿â»òÆäËüÊý¾Ý¿âΪÊý¾ÝÔ´¡£
ÇúÏßÊôÐÔÒ³ÖÐÉϰ벿·Ö¡°ÇúÏß¡±ÊǶ¨ÒåÇúÏßͼ±í³õʼ״̬µÄÇúÏß±äÁ¿¡¢»æÖÆÇúÏߵķ½Ê½¡¢ÊÇ·ñ½øÐÐÇúÏ߱Ƚϵȣº
? Áбí¿ò£ºÏÔʾÒѾÌí¼ÓµÄ±äÁ¿µÄÃû³Æ¼°»æÖÆ·½Ê½¶¨ÒåµÈ¡£ ? ¡°Ôö¼Ó¡±°´Å¥£ºÔö¼Ó±äÁ¿µ½ÇúÏßͼ±í£¬²¢¶¨ÒåÇúÏß»æÖÆ·½Ê½¡£
µ¥»÷¸Ã°´Å¥£¬µ¯³öÈçͼ3ËùʾµÄ¶Ô»°¿ò¡£
ͼ2 ÀúÊ·ÇúÏ߿ؼþ¹ÌÓÐÊôÐÔ
±±¾©ÑǿؿƼ¼·¢Õ¹ÓÐÏÞ¹«Ë¾
ÀúÊ·ÇúÏ߿ؼþʹÓ÷½·¨
ͼ3 Ôö¼ÓÇúÏß
?
±äÁ¿Ãû³Æ£ºÔÚ¡°±äÁ¿Ãû³Æ¡±Îı¾¿òÖÐÊäÈëÒªÌí¼ÓµÄ±äÁ¿µÄÃû³Æ£¬»òÔÚ×ó²àµÄÁбí¿òÖÐÑ¡Ôñ£¬¸ÃÁбí¿òÖÐÁгöÁ˱¾¹¤³ÌÖÐËùÓж¨ÒåÁËÀúÊ·¼Ç¼ÊôÐԵıäÁ¿£¬µ¥»÷Êó±êÑ¡Ôñ£¬ÔòÑ¡ÖеıäÁ¿Ãû³Æ×Ô¶¯Ìí¼Óµ½¡°±äÁ¿Ãû³Æ¡±Îı¾¿òÖС£ ÇúÏß¶¨Ò壺
ÏßÀàÐÍ£ºµ¥»÷¡°ÏßÀàÐÍ¡±ºóµÄÏÂÀÁбí¿ò£¬Ñ¡Ôñµ±Ç°Ñ¡ÔñµÄ±äÁ¿»æÖÆÇúÏßʱµÄÏßµÄÀàÐÍ¡£
ÏßÑÕÉ«£ºµ¥»÷¡°ÏßÑÕÉ«¡±ºóµÄ°´Å¥£¬ÔÚµ¯³öµÄµ÷É«°åÖÐÑ¡Ôñ»æÖƵÄÇúÏßµÄÑÕÉ«¡£
»æÖÆ·½Ê½£ºÇúÏߵĻæÖÆ·½Ê½ÓÐËÄÖÖ£ºÄ£Äâ¡¢½×ÌÝ¡¢Âß¼¡¢°ôͼ£¬¿ÉÒÔÈÎѡһÖÖ¡£
Òþ²ØÇúÏߣºÊÇ·ñÔÚ»æÖÆÇúÏßʱ³õʼÉèÖÃÒþ²Øµ±Ç°»æÖƵÄÇúÏß¡£ ?
ÇúÏ߱ȽϣºÍ¨¹ýÉèÖÃÇúÏ߱ȽÏʱ¼ä²î£¬Ê¹ÇúÏß»æÖÆÎ»ÖÃÓÐÒ»¸öʱ¼äÖáÉÏµÄÆ½ÒÆ£¬ÕâÑùͨ¹ý¹ØÁªµÄ±äÁ¿ÃûÏàͬ£¬µ«Ò»¸öÊÇÏÔʾÓëʱ¼äÖáÏàͬµÄʱ¼äµÄÊý¾Ý£¬ÁíÒ»¸ö×÷±È½ÏµÄÇúÏßÏÔʾÓëʱ¼äÖáµÄʱ¼ä²îΪij¸öÖµµÄÊý¾Ý£¨ÈçÒ»Ììǰ£©£¬´Ó¶ø´ïµ½ÓÃÁ½ÌõÇúÏßÀ´ÊµÏÖÁËÇúÏ߱ȽϵÄÄ¿µÄ¡£ ?
Êý¾ÝÀ´Ô´£ºÑ¡ÔñÇúÏßʹÓõÄÊý¾ÝÀ´Ô´£¬¿Éͬʱ֧³Ö×é̬ÍõÀúÊ·¿âºÍODBCÊý¾ÝÔ´¡£ÈôÑ¡ÔñODBCÊý¾ÝÔ´£¬±ØÐëÏÈÅäÖÃÊý¾ÝÔ´.¾ßÌåÅäÖ÷½·¨ÈçÏ£º
1¡¢ Æô¶¯¿ØÖÆÃæ°åÖеÄÊý¾ÝÔ´ODBC¡£µ¥»÷¡°ÏµÍ³DSN¡±Ïî¡£µ¥»÷¡°Ôö
¼Ó¡±£¬µ¯³ö¡°´´½¨ÐÂÊý¾ÝÔ´¡±¶Ô»°¿ò¡£
2¡¢ Ñ¡ÔñËùÐèÊý¾ÝÔ´µÄÇý¶¯Èç¡°Microsoft Accress Driver(*.mdb)¡±£¬µ¥»÷¡°Íê³É¡±°´Å¥¡£µ¯³ö¡°ODBC Microsoft Accress°²×°¡±¶Ô»°¿ò¡£ 3¡¢ ÔÚ¡°Êý¾ÝÔ´Ãû¡±Öж¨ÒåÒ»¸öÊý¾ÝÔ´Ãû³Æ£¬Êý¾Ý¿â¡°Ñ¡Ôñ¡±ÖÐÑ¡Ôñ
ÇúÏßÊý¾ÝËùÔÚµÄÊý¾Ý¿â£¬´ËÊý¾Ý¿âµÄ±íÖÁÉÙÓÐÈý¸ö×ֶΣºÊ±¼ä×ֶΡ¢Êý¾Ý×ֶΡ¢ºÁÃë×ֶΡ£µ¥»÷¡°È·¶¨¡±£¬Ð´´½¨µÄÊý¾ÝÔ´¾ÍÌí¼Óµ½¡°ÏµÍ³DSN¡±ÁбíÖС£
Êý¾ÝÔ´£ºÑ¡ÔñÇúÏßʹÓõÄÊý¾Ý¿â£¬ÔÚµ¯³öµÄ¡°Select Data Source¡±ÖÐ
Ñ¡ÔñÉÏÃæ¶¨ÒåµÄÊý¾ÝÔ´¡£ ±íÃû³Æ£ºÑ¡ÔñÇúÏßʹÓõÄÊý¾ÝÀ´×ÔËùÑ¡Êý¾Ý¿âµÄijһ¸ö±í ʱ¼ä×ֶΣºÑ¡ÔñÇúÏßÊý¾Ý¶ÔÓ¦µÄʱ¼ä¼Ç¼£¬ÈÕÆÚ/ʱ¼äÀàÐÍ Êý¾Ý×ֶΣºÑ¡ÔñÇúÏß¶ÔÓ¦µÄÊý¾ÝÖµ£¬³¤ÕûÐÍ»ò¸¡µãÐÍ ºÁÃë×ֶΣºÑ¡ÔñÇúÏßÊý¾Ý¶ÔÓ¦µÄºÁÃë¼Ç¼£¬Êý×ÖÀàÐÍ
ÎÞЧֵ£ºÃ¿Ò»ÌõÇúÏß¶¼ºÍ±íÖÐÒ»¸ö±íʾÆäÖµµÄ×ֶιØÁª£¬Õâ¸ö×ֶεÄÖµÔÚijһʱµã¿ÉÄÜÊÇÎÞЧµÄ£¬µ«±íµÄ½á¹¹¾ö¶¨ÁËÕâ¸ö×Ö¶ÎÔÚÒ»Ìõ¼Ç¼ÖеÄÖµ²»ÄÜΪ¿Õ°×£¬ËùÒÔ¾ÍÓÐÁËÎÞЧֵµÄ¶¨Òå¡£
±ÈÈ磺1£©µ±±íÖÐÊýÖµ×ֶεÄֵΪNULLʱ±íʾ¸ÃµãÊý¾ÝÎÞЧ£¬ÄÇô
ÅäÖÃÎÞЧֵʱ¾Í¿ÉÒÔ¿Õ¡£
2£©µ±±íÖÐÊýÖµ×ֶεÄֵΪ0ʱ±íʾ¸ÃµãÊý¾ÝÎÞЧ£¬ÄÇôÅäÖÃÎÞ
Чֵʱ¾Í¿ÉÒÔд0¡£
3£©µ±±íÖÐÊýÖµ×ֶεÄֵΪ¡°abcd¡±Ê±±íʾ¸ÃµãÊý¾ÝÎÞЧ£¬ÄÇô
±±¾©ÑǿؿƼ¼·¢Õ¹ÓÐÏÞ¹«Ë¾
?
ÀúÊ·ÇúÏ߿ؼþʹÓ÷½·¨
ÅäÖÃÎÞЧֵʱ¾Í¿ÉÒÔд¡°abcd¡±¡£
Ñ¡ÔñÍê±äÁ¿²¢ÅäÖÃÍê³Éºó£¬µ¥»÷¡°È·¶¨¡±£¬ÔòÇúÏßÃû³ÆÌí¼Óµ½¡°ÇúÏßÁÐ
±í¡±ÖС£Èçͼ4Ëùʾ£º
ͼ4 Ôö¼Ó±äÁ¿µ½ÇúÏßÁбí
ÈçÉÏËùÊö£¬¿ÉÒÔÔö¼Ó¶à¸ö±äÁ¿µ½ÇúÏßÁбíÖС£
? ¡°É¾³ý¡±°´Å¥£ºÉ¾³ýµ±Ç°Áбí¿òÖÐÑ¡ÖеÄÇúÏß¶¨Òå¡£ ? ¡°Ð޸ġ±£ºÐ޸ĵ±Ç°Áбí¿òÖÐÑ¡ÖеÄÇúÏß¶¨Òå¡£
? ¡°ÏÔʾÁÐ±í¡±Ñ¡ÏÊÇ·ñÏÔʾÈçͼ1ÖеÄÇúÏß±äÁ¿ÁÐ±í¡£ ? Êý¾ÝÔ´£ºÏÔʾÇúÏßʹÓÃÊý¾ÝÔ´µÄÐÅÏ¢¡£
2.2 ×ø±êϵÊôÐÔÒ³
Èçͼ2£¬µ¥»÷¡°×ø±êϵ¡±±êÇ©£¬½øÈë×ø±êϵÊôÐÔÉèÖÃÒ³£¬Èçͼ5Ëùʾ¡£
±±¾©ÑǿؿƼ¼·¢Õ¹ÓÐÏÞ¹«Ë¾