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

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¿ª·¢µÄÈí¼þ½øÐл¥Á¬ÍøÁ¬½Ó

±¾À´ÎÒÊÇÓÃACCESS+VB½¨Á¢Ò»¸öÈí¼þ£¨¾ÖÓòÍø£©£¬ÏÖÔÚÓÉÓڰ칫µØµãÓб䶯£¬Ïà»»³ÉINTERNATµÄ£¬ÓÐûÓа취½â¾ö£¬

ÏóÕâÑùµÄÇé¿ö£¬Èç¹ûÊǹãÓòÍø£¬×îºÃ¸Ä³É£ºB\SµÄ
Èç¹ûÊǾÖÓòÍøµÄ£¬×îºÃ¸Ä³É£ºC\SµÄ
http://downlo ......

ACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000

  ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......

ACCESSÆøËÀÎÒÁË£¬MD£¬×Ö¶ÎÖµ²»¶Ô

ÎÒÒª´Ó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 ......

access ²éѯ¼Ç¼µÄÎÊÌâ?

ÎÊÌâÈçÏ£º

ÓòéѯÓï¾ä
select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´
¸ÄΪ
select * from tab where fil = 'CK090902'
¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......

AccessÁ¬½ÓÓï¾ä²éѯ½á¹ûÓësql2005²»Ò»ÖÂ

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Ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ