AccessµÄbug
ÎÒÓÃAccessµÄʱºò£¬IDÊÇÖ÷¼ü×Ô¶¯Éú³É¡£ ÄDzåÈëÒ»Ìõ¼Ç¼µÄʱºò£¬ÔÚÖ´ÐÐÁ˲åÈëÓï¾äÖ®ºó»¹ÓÐÒ»¸ö´úÂëstring sqlGetId = "select max(Nid) from News" ; ÊÇÏë»ñÈ¡¸Õ²Å²åÈëµÄ¼Ç¼ËùÉú³ÉµÄID£¬¿ÉÊÇÿ´Î»ñÈ¡µ½µÄ¶¼ÊÇÉÏÒ»Ìõ¼Ç¼µÄID¡£ ÔÚSql ServerÀïȴûÕâ¸öÎÊÌâ°¡£¡
Ŷ£¬Ã»ÊÔ¹ý¡£Ð»Ð»LZ¸æÖ®£¬ÒÔºóÓöµ½ÕâÑùÊÂÇ飬¾ÍÖªµÀ°Ñ½á¹û+1¡£ºÇºÇÒýÓà Ŷ£¬Ã»ÊÔ¹ý¡£Ð»Ð»LZ¸æÖ®£¬ÒÔºóÓöµ½ÕâÑùÊÂÇ飬¾ÍÖªµÀ°Ñ½á¹û+1¡£ºÇºÇ ¼Ó1¸ü²Ò£¬ÒòΪÊý¾Ý²»¿ÉÄÜÍêÈ«Á¬Ðø°¡£¬¿ÉÄÜÖмäɾ³ýÁ˼¸ÌõҲ˵²»¶¨ ÓпÕÊÔÊÔ£¬ÎÒÓõÄÒ²ÊÇACCESS£¬¹À¼Æ¹Ø±ÕÁ¬½ÓºóÔÙËÑË÷¾ÍÕý³££¬ÄãÓõÄÊÇʲô°æ±¾£¿ ÎÒÓõÄÊÇ07£¬²åÈëºóËÑË÷·Ç×ÔÔö×ֶΣ¬¶øËÑË÷Ò»²»Öظ´Ëæ»úÊý×ֶΣ¬Õý³£ +1¸öÈËÈÏΪ²»¶Ô£¬ÒòΪÈç¹ûÊÇÀàËÆ¶àÏ̲߳úÉú²¢·¢µÄʱºò£¬ÄǾͲ»ºÃ˵ÁËÒýÓà ÓпÕÊÔÊÔ£¬ÎÒÓõÄÒ²ÊÇACCESS£¬¹À¼Æ¹Ø±ÕÁ¬½ÓºóÔÙËÑË÷¾ÍÕý³££¬ÄãÓõÄÊÇʲô°æ±¾£¿ ÎÒÓõÄÊÇ07£¬²åÈëºóËÑË÷·Ç×ÔÔö×ֶΣ¬¶øËÑË÷Ò»²»Öظ´Ëæ»úÊý×ֶΣ¬Õý³£ û¹Ø±Õ°¡¡£ÊÇÖØ¿ªÒ»¸öÁ¬½ÓÒýÓà û¹Ø±Õ°¡¡£ÊÇÖØ¿ªÒ»¸öÁ¬½Ó ͬÒâ£¬ÖØÐÂÁ¬½Ó£¬select maxidÒýÓà select @@identity Õâ¸öÒªºÍ²åÈë²Ù×÷ÔÚÒ»¸öÁ¬½ÓÒ»¸öÊÂÎïÖÐ Õâ¸öÔÚaccessÖÐÊÇ¿ÉÒÔ»ñÈ¡µ½Ð²åÈë×ÔÔöÊý¾ÝIDµÄ,ÎÒÇ××ÔÊÔÑé¹ý(access2003) ÇëÎÊÕâ¸öÔõôÓã¿select @@identity from News£¬½á¹ûÒ»Ö±¶¼ÊÇ0°¡ try: s
Ïà¹ØÎÊ´ð£º
±¾À´ÎÒÊÇÓÃACCESS+VB½¨Á¢Ò»¸öÈí¼þ£¨¾ÖÓòÍø£©£¬ÏÖÔÚÓÉÓڰ칫µØµãÓб䶯£¬Ïà»»³ÉINTERNATµÄ£¬ÓÐûÓа취½â¾ö£¬ ÏóÕâÑùµÄÇé¿ö£¬Èç¹ûÊǹãÓòÍø£¬×îºÃ¸Ä³É£ºB\SµÄ Èç¹ûÊǾÖÓòÍøµÄ£¬×îºÃ¸Ä³É£ºC\SµÄ http://downlo ......
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý" ²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!! ´ó¼Ò¶¼ ......
ÎÒÒª´ÓACCESS²éѯһÐÐÊý¾Ý,Êý¾Ý¿âÀïÓÐ ip£º192.168.2.71£¬192.168.2.55 SELECT COUNT(*) AS num from TreeNode WHERE ([ip]='192.168.2.55')£¬ÄÜÑ¡³öÊý¾ÝÀ´ SELECT COUNT(*) AS num from TreeNode WHE ......
ÎÊÌâÈçÏ£º ÓòéѯÓï¾ä select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´ ¸ÄΪ select * from tab where fil = 'CK090902' ¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......
SQL code: select count(1) from HouseList a left join MemberList b on (a.OperationName=b.UName and a.Eid=1 and a.houselc='2') ÒÔÉÏÕâÌõÓï¾äÔÚsql2005ÖвéѯµÃµ½760Ìõ¼Ç¼,·ÅÔÚaccessÖвéѯֻÓÐ14Ì ......