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

access 2000

ÎÒÓÃasp.net¼Óaccess 2000×öÁËÒ»¸ö¼òµ¥µÄµ÷²éÒ³Ãæ!
ÓÃoledbÁª½ÓÊý¾Ý¿â

¾ÍÓÃÁËÒ»¸öinsert into Óï¾ä¡£ÓÐÒ»¸ö×Ô¶¯Ôö¼Ó×ֶΡ£½á¹û¾ÍÌáʾ×Ö¶Î
ÊýÄ¿²»¶Ô¡£ÎÒɾ³ýÁË×Ô¶¯Ôö¼ÓµÄÄǸö×ֶκ󣬾ÍÊÇÕý³£µÄ¡£

Ôõô»á³öÀ´ÕâÖÖÄØ¡£ÎÒÓÃsql server ¾Í²»»á³öÀ´ÕâÖÖÎÊÌâ¡£ÓÃaccess ²Å³ö
ÏÖÕâÖÖÎÊÌâ

´óÏÀ °ï棬лл£¡
SQL code:
顯ʾָ¶¨×Ö¶ÎÄØ
insert(a,b)select c,d from tb


SQL code:
insert(a,b)select 'c','d'


sql server Ò²²»Äܵİɠ ×ÔÔöÁÐÊDz»ÄÜÖ±½Ó²åÈëÖµµÄ

ÕâÑùµÄ ±ítb
Id col1 col2 ...
IdÊÇ×Ô¶¯Ôö¼ÓµÄ

insert into tb values('sdf','dsf'...)

ÕâÑùÒª³ö´í

µ«ÊÇÈ´µôId¾Í²»»áÁË


-----------


Â¥ÉÏÊÇ˵ָʾһÏÂ×Ö¶Î insert into tb (col1,col2...) values('dfd','fdf'..)
Ŷ£¬ÎÒ¿ÉÒÔÊÔÊÔ£¡

ÒýÓÃ
sql server Ò²²»Äܵİɠ ×ÔÔöÁÐÊDz»ÄÜÖ±½Ó²åÈëÖµµÄ

ÎÒ²»ÊÇÖ±½Ó²åÈëÖµ.¾ÍÊÇûÓвåÈëÖµ²»ÐС£ÕæµÄ²åÈëÖµÁË»¹ÐÐÁË£¡

ÒýÓÃ
ÒýÓà 3 Â¥ fredrickhu µÄ»Ø¸´:
sql server Ò²²»Äܵİɠ ×ÔÔöÁÐÊDz»ÄÜÖ±½Ó²åÈëÖµµÄ

ÎÒ²»ÊÇÖ±½Ó²åÈëÖµ.¾ÍÊÇûÓвåÈëÖµ²»


Ïà¹ØÎÊ´ð£º

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

´íÎóÐÅÏ¢Access violation....

ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......

´´½¨ACCESSÎļþµ÷ÓÃOLEFUNCTIONʱ²úÉú´íÎó£¬ÔÚÏßÇóÖú

ÎÒÔÚCBÁ·´´½¨ACCESSÎļþ£¬
²ÉÓõÄÏÂÁдúÂë,ÎÒרÃÅÏÈ×ö¸öС³ÌÐò²âÊÔ£¬Ò»ÇÐÕý³£¡£
È»ºóÔÚ¼ÓÔØµ½1¸öÈí¼þÖУ¬
´«ÈëµÄ±äÁ¿MDB_PathNameÒ²ÊÇÕýÈ·µÄ¡£
µ«ÔÚÖ´ÐÐ
  mdb.OleFunction("Create", ......

ÈçºÎÔÚAccessÊý¾Ý¿âÖж¨Î»£¿

    ×î½ü×öÁËÒ»¸öÊý¾Ý¿â£¬±íÊÇÕâÑùµÄ£ºLatitude Longitude high time ;ÒÀ´Î¼Ç¼γ¶È ¾­¶È ¸ß³Ì ʱ¼ä£¬ÏÖÔÚÎÒÏ뽫Êý¾Ý

¿âÖмÇÔØµÄijһ¶Îʱ¼ä¶ÔÓ¦µÄγ¶È ¾­¶È ¸ß³ÌÖµ¶Á³öÀ´£¨¿ÉÒÔËæÒâÖ¸¶¨ÆðʼºÍÖÕÖ¹Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ