ҪʾÀý´úÂë ¹ØÓÚaccessµÄ»ù±¾²Ù×÷(2)
http://topic.csdn.net/u/20091119/08/72e9d486-7364-41b7-8c86-effe1cda216b.html
½ÓÉÏÒ³£¬Çë¼ÌÐøÌÖÂÛ
ÕâÀï²åÈë²»ÁËÁ´½Ó£¬ÇëÏÂÂ¥°ÑÉÏÃæµÄµØÖ·¸ÄΪÁ´½Ó
Õâ¸öÀý×Ó»¹Òª¿ª¼¸Ìù°¡£¿
ÍøÉϺܶà³ÌÐòŶ£¬Ëæ±ãgoogleһϾÍÕÒµ½ÁË
µ½µ×Òª¸ÉÂ´´½¨¸öÊý¾Ý¿âÈ»ºó²éѯ£¿Èç¹ûÕâÑùµÄ»°ÍøÉ϶àµÄÊÇ¡£¡£¡£¡£¡£¡£¡£
²»½â¡£¡£¡£¡£¡£
°ï¶¥,ËÑË÷һϰÉ,±È½Ï¼òµ¥
¼ÌÐø°É£¬ÒªÓкܸߵĴæÖüËÙ¶È£¬
Delphi(Pascal) code:
sql := 'create table MyTable (id int,data1 decimal(6,5) )';
//...
Query.SQL.Clear;
Query.SQL.Add('Insert into MyTable (id,data1 ) ');///´Ë´¦²»ÖªµÀÈçºÎд
for i:=0 to 100 do
Query.SQL.Add(' values ??? ');////´Ë´¦ÓÖÈçºÎÐ´ÄØ
Query.ExecSQL;
»¹ÓÐÆäËüÎÊÌâÂð
Ïà¹ØÎÊ´ð£º
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
ËüµÄ¶¨ÒåÊÇÕâÑùµÄ
_CRTIMP __checkReturn int __cdecl _access(__in_z const char * _Filename, __in int _AccessMode);
´ó¸ç£¬¿´¸öº¯ÊýÉùÃ÷¾ÍÄÜ¿´³öËû¸ÉɶµÄ£¿
´ÓÃüÃûÀ´¿´Ó¦¸ÃÊÇÅж ......
ÔÚ°¢ÅÁÆæµÄweb access logÖУ¬ÓÐÒ»¸öÊÇÓû§ÃûÑ¡ÏĬÈÏÊÇÓòÓû§Ãû¡£Èç¹ûÎÒÓõÄÊÇform ·½Ê½µÇ½£¬Ïë°ÑÕâ¸öÓû§Ãûдµ½access logÖÐÔõôʵÏÖ£¿
Â¥Éϵģ¬ ÏÖÔÚµÄaccess log ÊÇÕâÑùµÄ
2009-07-04 02:16:37 110.110 ......
win2000ϵͳADOÁ¬½ÓACCESSÊý¾Ý¿â±ØÐèÒª½øÈë×ÀÃæÂð?
ÎÒÓÐÒ»¸ö×°ÁËwin2000-SP4µÄ»ú×Ó,ÒÑ×°ÁËMDAC 2.8 ,дÁ˸öwindows·þÎñ³ÌÐòÊÇÓÃADO²Ù×÷ACCESSÊý¾Ý¿âµÄ,Ææ¹ÖµÄÊÇ´ò¿ªÊý¾Ý¿âÎļþʱ,±ØÐèÒªµÇ¼µ½×ÀÃæ²ÅÄÜÕý³£´ò¿ ......
delphi 2007 + access 2007 +odbc +TADODataset,TADOConnection,TADOCommand
//ɾ³ýÊý¾Ý
procedure TCDSSelectTools.DeleteMachine(byMachineID: string);
tmpCmd := TADOCommand.Create(ni ......