¶ÔÓÚDelphi 5 Êý¾Ý¿âÓ¦ÓÃÖÐODBCÊý¾ÝÔ´µÄ×Ô¶¯¹ÜÀí
ÕªÒªÕªÒª£º±¾ÎÄ·ÖÎöÁËODBCÊý¾ÝÔ´ÉèÖõÄÔÀíÒÔ¼°ODBCÊý¾ÝÔ´ºÍDelphiÊý¾Ý¿â±ðÃûµÄ¹Øϵ¡£²¢ÔÚ´Ë»ù´¡ÉÏ£¬½éÉÜÁËÔÚDelphi5Êý¾Ý¿âÓ¦ÓóÌÐò°²×°¡¢ÔËÐÐÖУ¬ÈçºÎ±à³ÌʵÏÖODBCÊý¾ÝÔ´ºÍDelphiÊý¾Ý¿â±ðÃûµÄÉèÖá£
¹Ø¼ü×ÖÕªÒª£ºDelphi¡¢Êý¾Ý¿â¡¢ODBC
Ò»¡¢Ç°ÑÔ
DelphiµÄÌØÉ«Ö®Ò»¾ÍÊÇ·½±ã¶øÇ¿´óµÄ¿ª·¢Êý¾Ý¿âµÄÄÜÁ¦£¬Ö»ÒªÇá»÷¼¸ÏÂÊó±ê£¬Ìîд¼«Éٵļ¸ÐдúÂ룬¾ÍÄÜ¿ìËٵؿª·¢³öºÜÓзç¸ñµÄÊý¾Ý¿âÓ¦ÓóÌÐò¡£±àдһ¸öÊý¾ÝÓ¦ÓÿÉÒԺܼòµ¥£¬µ«ÒªÔÚ±ðÈ˵ļÆËã»úÉÏÔËÐÐ×Ô¼ºµÄÓ¦ÓÃÈ´Òª·ÑһЩÖÜÕÛ¡£
Ê×ÏÈ£¬¼ÙÈç¶Ô·½µÄ¼ÆËã»úÉÏ»¹Ã»Óа²×°¹ýInprise¹«Ë¾µÄBDEÊý¾Ý¿âÒýÇæµÄ»°£¬ÄÇô¾Í±ØÐë°ÑBDEºÍÓ¦ÓóÌÐòÒ»Æð°²×°µ½¶Ô·½µÄ¼ÆËã»úÖС£Æä´Î£¬Ó¦ÓóÌÐòÖÐÓõ½µÄÊý¾Ý¿â±ðÃû£¨Alias£©£¬·Ç·²ÊÇʹÓÃÁËODBCÊý¾ÝÔ´Á¬½ÓµÄÊý¾Ý¿â±ðÃû±ØÐëºÍBDEÒ»ÆðÉèÖá£×îºó£¬¼ÙÈçÓ¦ÓóÌÐòʹÓõÄÊý¾Ý¿â£¬Æä´æ·Å·¾¶²¢²»Êǹ̶¨µÄ£¬ÄÇô±ØÐë¸ù¾Ýʵ¼ÊÇé¿ö½øÐÐODBCºÍAliasµÄµ÷Õû¡£ÕâЩ£¬µ±È»¿ÉÒÔÔÚÓ¦ÓóÌÐò°²×°ºó£¬ÀûÓÿØÖÆÃæ°åÖÐODBCÊý¾ÝÔ´¹ÜÀíºÍBDEËæ´øµÄBDE Administratorͨ¹ýÊÖ¹¤ÉèÖᣵ«Èç´ËÒ»À´£¬Ò»·½Ãæ»áʹӦÓóÌÐò´ó´òÕÛ¿Û£¬ÁíÒ»·½Ãæ²»±ãÓÚÆÕͨÓû§×Ô¼ºµÄ°²×°ºÍ½ñºó¹¤×÷·¾¶µÄ¸Ä¶¯¡£
ºÍDelphiÒ»Æð·¢²¼µÄInstall Shield Express¿ÉÒÔ´ó´ó¼ò»¯°²×°³ÌÐòµÄÖÆ×÷£¬°ïÖúÎÒÃÇÍê³ÉÐí¶à¹¤×÷¡£±¾ÎĽ«Òª½éÉܵģ¬±ãÊÇÈçºÎͨ¹ýInstall ShieldºÍÓ¦ÓóÌÐòÅäºÏ£¬Íê³É°²×°ºÍÔËÐÐʱµÄODBCÊý¾ÝÔ´µÄ×Ô¶¯ÉèÖá£
¶þ¡¢ÔÀí
1¡¢ODBCÊý¾ÝÔ´
ODBC£¨Open DataBase Conectivity£©ÊÇ΢Èí¹«Ë¾Öƶ¨µÄ±ê×¼±à³Ì½Ó¿Ú£¬Ö»ÒªÓÐÏàÓ¦µÄODBCÇý¶¯³ÌÐò£¬¾Í¿ÉÒÔͨ¹ýODBCÁ¬½á²Ù×÷¸÷ÖÖ²»Í¬µÄÊý¾Ý¿â¡£Í¨³£Í¨¹ý¿ØÖÆÃæ°åÖеÄODBC Data SourceÀ´ÅäÖÃODBCµÄÊý¾ÝÔ´¡£ËùνODBCÊý¾ÝÔ´¾ÍÊÇÃüÃûµÄÒ»×éÐÅÏ¢£¬°üÀ¨ÐèÒªÁ¬½áµÄÊý¾Ý¿âËùÔÚλÖ㨿ÉÒÔÊÇ´ÅÅÌĿ¼/Îļþ£¬Ò²¿ÉÒÔÊÇÍøÂç·þÎñÆ÷£©¡¢¶ÔÓ¦µÄODBCÇý¶¯³ÌÐòÒÔ¼°·ÃÎÊÊý¾Ý¿âËùÐèµÄÆäËûÏà¹ØÐÅÏ¢£¬Óû§¿ÉÒÔͨ¹ýÊý¾ÝÔ´µÄÃû³Æ(DSNs£¬Data Source Names)À´Ö¸¶¨ËùÐèµÄODBCÁ¬½Ó¡£
DSNs°´ÕÕÆä±£´æ·½Ê½ºÍ¹¦ÄÜ·¶Î§·ÖΪÈýÖÖÕªÒª£ºÓû§DSN¡¢ÏµÍ³DSNºÍÎļþDSN¡£Ã¿¸öÎļþDSN±£´æÔÚµ¥¶ÀµÄÒ»¸öÎļþÖУ¬Îļþ¿ÉÒÔÔÚÍøÂ緶ΧÄÚ¹²Ïí£»Óû§DSN±£´æÔÚ×¢²á±íÖУ¬Ö»¶Ôµ±Ç°Óû§¿É¼û£»ÏµÍ³DSNÒ³±£´æÔÚ×¢²á±íÖУ¬µ«¶ÔϵͳÖеÄËùÓÐÓû§¿É¼û¡£Óû§DSNºÍϵͳDSNµÄÇø±ðÔÚÓÚ£¬Óû§DSN±£´æÔÚ×¢²á±íµÄHKEY_CURRENT_USERÏ£¬¶øϵͳDSN±£´æÔÚHKEY_LOCAL_MACHINEÏ¡£
ÏÂÃ棬ÒÔϵͳDSNΪÀý˵Ã÷ÈçºÎͨ¹ýÐÞ¸Ä×¢²á±íÖ±½ÓÉèÖÃODBCÊý¾ÝÔ´¡£¼Ù¶¨ÎÒÃÇÒªÁ¬½ÓµÄÊý¾
Ïà¹ØÎĵµ£º
н¨Ò»¸öActive Library
2. н¨Ò»¸öCOM Object£¬ÔÚClass NameÌîÒ»¸öÃû×Ö£¬ÈçTest¡£
µãÒ»ÏÂImplemented InterfaceºóÃæµÄList°´Å¥¡£ÔÙµãһ϶Ի°¿òÖеÄAdd Library°´Å¥£¬
Ñ¡Ôñ“Program Files\Common Files\Designer”Ŀ¼ÏµÄmsaddndr.dllÎļþ¡£
È»ºóÔÚÁбíÖÐÕÒµ½msaddndr.dllÀïÃæµÄ_IDTExtensibility2½Ó¿Úµã ......
WebBrowser×é¼þºÍMSHTML ÔÚDelphiÖеÄʹÓÃ
ÓÉÓÚÏîÄ¿ÐèÒª£¬½üÀ´Ñо¿ÁËÒ»ÏÂWebBrowser×é¼þºÍMSHTML ÔÚDelphiÖеÄʹÓÃ,ÕûÀíÁËÒ»ÏÂÕâ¶Îʱ¼äÑо¿µÄ½á¹û,дÏÂÀ´Ò»ÊÇ·½±ã´ó¼Ò²éÔÄ,¶þÒ²¿ÉÒÔ¼ÓÉîÎÒ×Ô¼ºµÄ¼ÇÒä.Ï£ÍûÄܶԴó¼ÒÓÐËù°ïÖú… …,ͬʱ,Èç¹ûÓиüºÃµÄ´¦Àí·½Ê½»òÕßÎÒûÓÐÌáµ½µÄÎÊÌâ,Çë´ó¼ÒÒ²¸æËßÎÒŶ, ÔÛÃÇÒ» ......
DelphiµÄTCanvasÒÔ¼°ÅÉÉúÀàÌṩÁËÏÔʾTGraphicͼÏñµÄ·½·¨Draw£¬ÆäʵÕâ¸ö·½·¨±¾Éí²¢Ã»ÓÐÏÔʾͼÏñµÄ¹¦ÄÜ£¬Ö»ÊÇ·´¹ýÀ´µ÷ÓÃÁËÒ»ÏÂTGraphicµÄDraw·½·¨¡£TGraphic±¾ÉíÊǸö³éÏóÀ࣬ÆäDraw·½·¨Ò²ÊǸö´¿Ðé·½·¨£¬ËùÒÔTGraphicµÄËùÓÐÅÉÉúÀà±ØÐëÌṩһ¸ö¾ßÌåµÄDraw·½·¨¡£TGraphicµÄÖ÷ÒªÅÉÉúÀàTBitmapÒ²ÓÐÒ»¸öDraw·½· ......
×ܽáÒ»ÏÂSQLÓï¾äÖÐÒýºÅ(')¡¢quotedstr()¡¢('')¡¢format()ÔÚSQLÓï¾äÖеÄÓ÷¨ÒÔ¼°SQLÓï¾äÖÐÈÕÆÚ¸ñʽµÄ±íʾ(#)¡¢('')
ÔÚDelphiÖнøÐÐ×Ö·û±äÁ¿Á¬½ÓÏà¼Óʱµ¥ÒýºÅÓÃ('''),ÓÖÒýºÅÓÃ('''')±íʾ
Ê×Ïȶ¨Òå±äÁ¿
var
AnInt:integer=123;//ΪÁË·½±ãÔڴ˶¼¸øËüÃǸ³³õÖµ¡£ËäÈ»¿ÉÄÜÔÚÒý¸³³õÖµÔÚijЩÇé¿öϲ»¶Ô
AnIntStr:string='456'; ......
µÚÒ»Õ DELPHIµÄÔ×ÓÊÀ½ç
µÚ¶þÕ DELPHIÓëWIN32ʱ¿Õ
µÚÈýÕ ¶àÏß³Ì
µÚËÄÕÂ ½Ó¿Ú
µÚÎåÕÂ °ü
µÚÁùՠʼþÓëÏûÏ¢
µÚÆßÕ ×éÖ¯ÄãµÄÄ£¿é
µÚ°ËÕ ̽Ë÷Êý¾Ý¿â
µÚ¾ÅÕ ¶à²ãÌåϵ½á¹¹
µÚʮՠ²Ù×÷½çÃæÓë²Ù×÷Âß¼
µÚʮһÕ ÃæÏò¶ÔÏóÊý¾Ý¿â»ù´¡
µÚÎåÕÂ&n ......