VFP ·R¥ÎªÌªÀ°Ï ­º­¶ VFP ·R¥ÎªÌªÀ°Ï
¥»°Q½×°Ï¬° Visual Foxpro ·R¥ÎªÌ¸gÅç¥æ¬yªº¦a¤è, ½Ð¦h¦h§Q¥Î"·j´M"ªº¥\¯à, ¥ý¬d¬Ý¬Ý¦³µL«e¨Ò¥i´`, ¦pªGÁÙ¦³¤£À´ªº¦Aµo°Ý. ³¡¥÷¥DÃD¦³ªþ¥[ÀÉ®×, ¶·¥ýµù¥U¦¨¬°ªÀ°Ï©~¥Á¤~¥i¥H¤U¸ü.
 
 ±`¨£°ÝÃD±`¨£°ÝÃD   ·j´M·j´M   ·|­û¦Cªí·|­û¦Cªí   ·|­û¸s²Õ·|­û¸s²Õ   ·|­ûµù¥U·|­ûµù¥U 
 ­Ó¤H¸ê®Æ­Ó¤H¸ê®Æ   µn¤JÀˬd±zªº¨p¤H°T®§µn¤JÀˬd±zªº¨p¤H°T®§   µn¤Jµn¤J

¦bVFP¤¤«Ø¥ßC¡þS¾÷¨î(Âà¶K)

 
µoªí·s¥DÃD   ¦^ÂÐ¥DÃD    VFP ·R¥ÎªÌªÀ°Ï ­º­¶ -> VFP °Q½×°Ï
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD  
µoªí¤H ¤º®e
Ruey



µù¥U®É¶¡: 2003-03-12
¤å³¹: 1698
¨Ó¦Û: tunglo

²Ä 1 ¼Ó

µoªíµoªí©ó: ¬P´Á¤G ¤K¤ë 26, 2003 1:30 pm    ¤å³¹¥DÃD: ¦bVFP¤¤«Ø¥ßC¡þS¾÷¨î(Âà¶K) ¤Þ¨¥¦^ÂÐ

¦bVFP¤¤«Ø¥ßC¡þS¾÷¨î
¤@¡BC¡þSªºÀ³¥Î§Î¦¡
¦bÀ³¥Î¤¤¡A¤H­Ì¦h§âC¡þSªºÀ³¥Îµ{¦¡¤À¦¨¨â³¡¤À¡GÅý«È¤áµ{¦¡¾n¯d¦bºô¸ôªº«eºÝ¤u§@¯¸¡]¤@¥x·L¾÷¡^¤W¡A¦øªA¾¹³B²zµ{¦¡«h¦bºô¸ôªº«á»O¡A¨ä¤À§Gµ²ºc¨£¹Ï1¡C·í«È¤á¡]¦b¤u§@¯¸¤W¡^³q¹L½Ð¨Dªº¤è¦¡´£¥X¤F©Ò»Ý­nªºªA°È®É¡A¦øªA¾¹¤£¥²Ãö¤ß«È¤áµ{¦¡ªº¥\¯à¡A¥u»Ý¦^À³½Ð¨D´N¦æ¡C
¦b³oºØµ²ºc¤¤¡A¦øªA¾¹ªºµwÅ饲¶·¨ã¦³¨¬°÷ªº³B²z¯à¤O¡A³o¼Ë¤~¯àº¡¨¬¦U«È¤áªº­n¨D¡C
±q·§©À¤W¬Ý¡A¡§¦øªA¾¹¡¨ªº§t¸q«D±`¼sªx¡A¸ê®Æ®w¦øªA¾¹¥u¬O¨ä¤¤ªº¤@ºØ¡C¸ê®Æ®w¦øªA¾¹¦Ü¤ÖÀ³´£¨Ñ¹ï¸ê®Æªº¦s¨ú¡B¥[¤u¡B³B²zµ¥ªA°È¡A¦P®ÉÁÙ­n´£¨Ñ§¹µ½ªº¦w¥þ«OÅ@¤Î¸ê®Æªº§¹¾ã©Êµ¥³B²z¡A¨Ã¤¹³\¦h­Ó«È¤á¦P®É³X°Ý¦P¤@­Ó¸ê®Æ®w¡C¦]¦¹¡A«È¤á¥i¥H¤£¥Î¦Ò¼{¹ï¸ê®Æªº¦w¥þ¡BÀu¤Æ¡B§¹¾ã©Êµ¥°ò¦³B²z¡A¥u»Ý±M¤ß¦Û¤vªº¤u§@¡C
«È¤áÀ³¥Îµ{¦¡°£¤F¦V¦øªA¾¹´£¥X½Ð¨D¥~¡AÁÙ­n¤ÀªR±q¦øªA¾¹ªð¦^ªº¸ê°T¡]¥]¬A¸ê®Æ©M«ü¥O¡^¡A¨Ã¾Ú¦¹§@¤@¨Ç¦A³B²z¡]¦p¦V¾Þ§@ªÌÅã¥Ü¬ÛÀ³ªº¸ê®Æ¡B­n¨D¸É¥R¿é¤J¤@¨Ç¸ê®Æµ¥¡^¡C
¥ò¤¶¡]MiddleWare¡^¬OC¡þS¨t²Î¤¤ªº¤@ºØ¨t²Î³nÅé¡A¥¦­t³dÃìµ²«È¤á»P¦øªA¾¹¡C«È¤á»P¦øªA¾¹Áp±µªº³Ì©³¼h¬Oºô¸ôªºµwÅé¡A¦ý¹ïÀ³¥Î¯Åªºµ{¦¡®v¨Ó»¡¡AÃö¤ßªºµJÂIÁÙ¬O¥¦­Ì¦b³nÅé¤Wªº³q«HÃìµ²¡C¦]¬°C¡þSªºÀô¹Ò½ÆÂø¡A¦Ó¥B¯A¤Î¦hºØ³Wµ{¤Î¨óij¡A©Ò¥HÁÙ¥²¶·¨Ì¾a¥ò¤¶³nÅé¤~¯à¦³®Ä¦a­°§C¤u§@Ãø«×¡C¥ò¤¶³nÅé¯à°÷§â¨Ï¥ÎªÌ»P½ÆÂøªº³q«H³Wµ{¡BµwÅ饭»O¤Î§@·~¨t²Î¹j¶}¡A¸ê®Æ³q¹L¥ò¤¶¦b«È¤á»P¦øªA¾¹¶¡¬y°Ê¡A«È¤á»P¦øªA¾¹³q¹L¥ò¤¶³nÅé¶i¦æ¥­Ã­¤¬³X¡A³oºØ¤è¦¡µLºÃ¤j¤j­°§C¤F½sµ{ªÌªº§Þ³NÃø«×¤Î¤u§@¶q¡C
¥Ø«e¤w¥X²{¤F«Ü¦h¦³Ãö¥ò¤¶ªº¼Ð·Ç¤Î³nÅé¡A§Ú­Ì¦bViúQsualFoxPro¤W¨£¨ìªº´N¬OODBC¡C¥¦³B¦b«È¤á»P¦øªA¾¹¤§¶¡¡A¦³®Ä¦aÁô½ª¤FC¡þS¾Þ§@ªº½ÆÂø¹Lµ{¡C
¤G¡B³]­pC¡þS¨t²Îªº°ò¥»­ì«h
³oùØ¥u¦Ò¼{«È¤á»P¦øªA¾¹¤À§O¦b¤£¦PµwÅ饭»O¤WªºC¡þS¨t²Î¡]§Y°ò©óºô¸ôªºC¡þS¨t²Î¡^¡A¥¦­Ì¦b³]­p®ÉÀ³¿í´`¥H¤U­ì«h¡G
1¡D¾¨¶qÅý«È¤á¾÷§¹¦¨°w¹ï¯S©w¥Î¤áªº¨Æ°È³B²z
¦]¬°¦øªA¾¹¥Ñ¦h­Ó«È¤á¾÷¦@¥Î¡A¦pªG§â¨C­Ó¥Î¤áªº¯S©w³B²z³£©ñ¦b¦øªA¾¹¤W¡A´N·|¼W¤j¦øªA¾¹ªº¤u§@¶q¡A¦]¦Ó­°§C¨ä¦^À³³t«×¡A©µªø«È¤á¥Ó½Ðªºµ¥«Ý®É¶¡¡A©Ò¥H¾¨¶qÅý«È¤á¾÷§¹¦¨°w¹ï¯S©w¥Î¤áªº¨Æ°È³B²z¡A¥Øªº¬O¬°¤F´î»´¦øªA¾¹ªº­t¾á¡A´£°ªC¡þS¨t²Îªº¾ãÅé©Ê¯à¡C
2¡D¾¨¶qÅý¦øªA¾¹ºÞ²z¥þ³¡ªº¦@¥Î¸ê·½
¥i¦@¥Îªº¸ê·½¥]¬A¸ê®Æ¡B³¡¤À¥~³]¡]¦p±½´y¾¹¡B¦Lªí¾÷µ¥¡^¤Î°ò¦ªA°È³B²z¡]¦p³q«H¡^¡A³o¨Ç³£À³¥Ñ¦øªA¾¹¨ÓºÞ²z¡A¥H«OÃÒ¦U¥Î¤á³£¯à¨É¥Î¡C¹ï©ó¦@¥Î¸ê®Æ¡A¥Ñ¦øªA¾¹¶°¤¤³B²zÁÙ¦³§U©ó«OÃÒ¸ê®Æªº§¹¾ã©Ê¡B¤@­P©Ê©M¦w¥þ©Ê¡C
3¡D¾¨¶q´î¤Ö«È¤á»P¦øªA¾¹¶¡¶Ç°eªº¸ê®Æ¶q
¦bºô¸ô¶¡¶Ç°e¸ê®Æ¡A¥i¯à²£¥Í¸ê®Æ¿ù»~¡B¥á¥¢¡B©µ®É¡B¬G»Ùµ¥°ÝÃD¡C¸ê®Æ¶Ç»¼±o¶V¦h¡A²£¥Íªº°ÝÃD¡B­n¨D«ì´_ªº¥i¯à©Ê¤]´N¶V¤j¡C¦Ó¥Bºô¸ô¤W°ï¿n¤F¤j¶q¸ê®Æ¡A¥²µM·|­°§C¨t²Î¹ï¨ä¥L«È¤á¾÷ªº¤ÏÀ³³t«×¡A¦P®É¼vÅT«È¤á¤§¶¡¤Î«È¤á»P¦øªA¾¹¶¡ªº³q«H¡]³q«H¤]¬O¤@ºØ¦@¥Î¸ê·½¡^¡C©Ò¥H¡A´î¤Öºô¸ô¤¤¸ê®Æªº¶Ç»¼¶q¡A¦³§U©ó«OÃÒC¡þS¨t²Îªº¾ãÅé©Ê¯à¡C
4¡D°í«ù§½³¡¸ê®Æ¦b§½³¡¦sÀx©MºÞ²z
³o¬O¬°¤F´î¤Öºô¸ô¤Wªº¸ê®Æ¶Ç¿é¶q¡B´î»´¦øªA¾¹ªºÀ£¤O¡B¼W±j¦øªA¾¹¹ï½Ð¨Dªº¦^À³¡A´£°ªC¡þS¨t²ÎªºÁ`Åé©Ê¯à¡C
®Ú¾Ú¤W­z­ì«h¡A¦b°µ°ò©ó¸ê®Æ®wªºC¡þS¨t²Î³]­p®É¡A¥i¥H§â¤¶­±ªí¥Ü³¡¤À¡]¦p¿é¤J¡B¿é¥X¤¶­±¡^©ñ¦b«È¤á¾÷¤W¡A§â¸ê®ÆªººÞ²z³¡¤À¡]¦p¬d¸ß¡B¦sÀx¡B§ó·s¡BÀu¤Æµ¥¡^©ñ¦b¦øªA¾¹¤W¡C¹ï¨ä¥L³B²zÅÞ¿è¡A«h­n®Ú¾Ú¨ãÅ鱡ªp¶i¦æ¤ÀªR¡A¨Ò¦p¹ï©ó­pºâ±K¶°«¬ªº³B²z¡A¥i§â­pºâ³¡¤À©ñ¦b«È¤á¾÷¤W¡A¦Ó¦³Ãö¸ê®Æ¯S©Êªº¤@¯ë¬ù§ô³B²z¡]¦p§¹¾ã©Ê¡B¦w¥þ©Ê¡B¤@­P©Êµ¥¡^«h¥i©ñ¦b¦øªA¾¹¤W¡C
¹ï©ó¸ê®Æªº¤À§G¡A¤]À³§@§´µ½¦w±Æ¡C¹ï©ó´£¨Ñµ¹¦U«È¤á¦@¥Îªº¸ê®Æ¡AÀ³©ñ¦b¦øªA¾¹¤W¡]§@¬°»·ºÝ¸ê®Æ¨Ó³B²z¡^¡F¦Ó¹ï©ó¦U¦Ûªº¿W¥Î¸ê®Æ¡A«hÀ³©ñ¦b¦Û¤vªº«È¤á¾÷¤W¡C
¤T¡BVisualFoxPro¤¤«Ø¥ßC¡þSªº¾÷¨î
¥ÎVisualFoxProºc³yC¡þS¨t²Î®É¡A¥ÎODBC§@¥ò¤¶³nÅé¡A¥ÑODBC§¹¦¨«È¤á»P¦øªA¾¹¶¡ªº³q«H¡C³o®É¦UÀ³¥Îµ{¦¡³£³q¹L¦U¦ÛªºÅX°Êµ{¦¡»P¸ê®Æ®w¬ÛÁp¡AODBC³q¹L¦Û¨­ªºÅX°Êµ{¦¡ºÞ²z¾¹¨ÓºÞ²zODBC»PÅX°Êµ{¦¡¶¡ªº¥æ¤¬¡Aµ{¦¡®v«h¥i¥H¨Ï¥Î¬Û¦Pªºµ{¦¡½Õ¥Î¨Ó¹ê²{»P¤£¦P¸ê®Æ·½ªº³q«H¡C
¥Ø«e¡AWindows¤UªºODBCÅX°Êµ{¦¡©MÅX°Êµ{¦¡ºÞ²z¾¹§¡¥HDDL¡]°ÊºA¸ê®Æµ{¦¡®w¡^ªº§Î¦¡¹ê²{¡C¦bVisualFoxProªºODBC¤ä´©¤U¡A«È¤áªºÀ³¥Îµ{¦¡¥i¥H¹ê²{¥H¤U¥\¯à¡G
①»P¡]»·ºÝ¡^¸ê®Æ®w«Ø¥ß©Î¸Ñ°£Áp±µ¡F
②VisualFoxPro¥i³q¹L·í«e¤w¦³ªºÅX°Êµ{¦¡»POraúQcle7¡D0¡BSQLServer¡BMSParadoxµ¥¸ê®Æ®wÁp±µ¡C¨ä¥LºØÃþªº¸ê®Æ®w¥u­n¯à´£¨Ñ¦Û¤vªºÅX°Êµ{¦¡¡A¤]¯à»PVisualFoxPro¬ÛÁp¡F
③¹ï»·ºÝ¸ê®Æ®w¶i¦æ±`³W¾Þ§@¡]¦p­×§ï¡B¬d¸ßµ¥¡^¡A¨ÃÀò¨ú¬ÛÀ³ªº¾Þ§@µ²ªG¡F
④±µ¦¬¥HANSIError¬°¼Ð·Çªº¿ù»~¸ê°T¡F
⑤¹ï»·ºÝ¸ê®Æ®w¤Wªºªí¡B°O¿ý¡Bµø¹Ï¡B¯Á¤Þµ¥¶i¦æÀË´ú¡F
⑥¦V¦U¥Î¤á´£¨Ñ²Î¤@ªºµn¿ý¤¶­±¡C
VisualFoxPro¬OC¡þSªº«eºÝ¶}µo¤u¨ã¡A¥¦³q¹LODBC¹ï«áºÝ¸ê®Æ®w¶i¦æ¦s¨úªº¤èªk¦³¨âÃþ¡GSPT¡]SQLPass¡ÐThough¡^©MRemoteViews¡]»·µ{µø¹Ï¡^¡CSPT´£¨Ñªº¨ç¼ÆÃþ¦ü§C¯ÅÀɨç¼Æ¡A¥Î¤á¥i¥Î¦¹ª½±µ³X°Ý«áºÝ¸ê®Æ®w¡C¥Î¤á¨Ï¥ÎSPT®É¡A»Ý¥Î¤@²Õ¥HSQL¥´ÀYªº¨ç¼Æ¨Ó½s¼g¡§¥´¶}Áp±µ¡¨¡B¡§¿ù»~ÀË´ú¡¨¡B¡§©R¥O¶Ç»¼¡¨µ¥«ü¥O¡CVisualFoxPro¤¤ªºµø¹Ï¦³¨âºØ¡G¥»¦a©M»·ºÝ¡A¾Þ§@®É¥i¤@µø¦P¤¯¡C»·ºÝµø¹Ï¦bViewDesigner¤¤³Ð«Ø¡A³o®É»Ý»¡©ú»·ºÝ¸ê®Æ®w¤¤­n³X°Ý©Î­×§ïªº¡§³¡¦ì¡¨¤Î½d³ò¡C·í³o­Óµø¹Ï«Ø¥ß«á¡A§Ú­Ì´N¥i¥H¹³¨Ï¥ÎViúQsualFoxProªº¤@­Ó§½³¡ªí¤@¼Ë¡A¥Î¡§¤é±`¡¨ªºVisualFoxPro©R¥O¹ï¨ä¾Þ§@¡C
³X°Ý«áºÝ¸ê®Æ®w®É¡A¥²¶·¥ý³q¹LÁp±µ¡C¦bVisualFoxPro¤¤¡A³q¹LÁp±µ¥i¥H³Ð«Ø»·ºÝµø¹Ï¡A­×§ï¨äÄÝ©Ê«h¥i¥HÀu¤Æ¦U³¡¤À¶¡ªº³q«H¡CVisualFoxPro¤¤ªºÁp±µ¦³¨âºØ¡GÁô§tÁp±µ©M©R¦WÁp±µ¡C³oùØÁp±µ³Q·í§@ª«¥ó¨Ó³B²z¡A¥H¤U¬OÁp±µ¤¤±`¥Îªº¤@¨ÇÄÝ©Ê¡G
ÄݩʦW¤º®e»¡©ú
PassWordÁp±µ®É¥Îªº¤f¥O
DataSource³q¹LODBC©ÒÁp±µ¸ê®Æ·½ªºÃþ«¬
PacketSize½T©wÁp±µ®É©Ò¥Îºô¸ô¸ê®Æ¥]ªº¤j¤p
ConnectString¥Î©óÁp±µµù¥Uªº¦r¦ê
Asynchronous½T©w©Ò¥ÎÁp±µ¬O¦P¨BÁÙ¬O«D¦P¨B
ConnecName«Ø¥ß´å¼Ð®É©Ò¥ÎÁp±µªº¦W¦r
UserID¥Î¤á¼ÐÃÑ
Shared½T©wÁp±µ®É¥i§_¦@¥Î
PatchMode½T©w§å¼Ò¦¡
¡K¡K
¦b¥ÎSPT³X°Ý«áºÝ¸ê®Æ®w®É¡A¥²¶·¨Ï¥Î©R¦WÁp±µ¡C
¦b¤@¯ëªºÀ³¥Î¤¤¡A¥i¥H±N»·ºÝµø¹Ï»PSPTµ²¦X¨Ï¥Î¡C¥i¦b¥»¦a¸ê®Æ®w¤¤©w¸q«áºÝ¸ê®Æ·½ªº»·ºÝµø¹Ï¡AµM«á³q¹LForm¡]©ÎFormSet¡^¹ï¤wÁp¸ê®Æ·½¶i¦æ¤é±`¾Þ§@¡C³o¬O¤@ºØ²¼ä¡B¹ê¥ÎªºC¡þS¨t²ÎÀ³¥Î¡C
¥|¡B¥ÎVFP¹ê²{C¡þS¨t²Îªº°ò¥»¤èªk
¦b«Ø¥ßC¡þS¨t²Î®É¡A¹ê²{¨BÆJ¬°¡G
²Ä¤@¨B¡A®Ú¾Ú«áºÝ¸ê®Æ·½ªºÃþ«¬¸Ë¤J¬ÛÀ³ªºODBCÅX°Êµ{¦¡¡A¦P®É°µ¤@¨Ç¬ÛÀ³ªº³]¸m¡C
¤U­±¥H¦w¸ËSQLServerªºÅX°Êµ{¦¡¬°¨Ò¶i¦æ»¡©ú¡G
DataSourceName¼ÐÃѸê®Æ·½ªº¦W¤l
Description»¡©ú¦sÀx¦b¸ê®Æ·½¤¤ªº¸ê®Æ
Server¼ÐÃѺô¸ô¤WSQLServerªº¦W¦r¡A¥Ø«e¥i¿ïªº¦øªA¾¹¦³MSWindowsforworkgroups¡FBanyanVINES¡FMSLANManager¡FIBMLANServer©ÎDECPathworks¡FTCP¡þIPNetworks¡FNovellNetWare¡C
NetworkAddress»¡©úSQLServerDBMSªººô§}
NetworkLibrarySQLServerÅX°Êµ{¦¡©Ò¥Îªº»Pºô¸ô³q°Tªº°ÊºA³sµ²µ{¦¡®w
ÁÙ¦³¨ä¥L¤@¨Ç¥Î©ó»¡©ú½Ñ¦p¸ê®Æ®w¦W¡B©Ò¥Î»y¨¥µ¥¿ï¶µªº°Ñ¼Æ¡A»Ý®Ú¾Ú±¡ªp½T©w¡C³]¸m§¹¤W­z°Ñ¼Æ«á¡A§Y§¹¦¨¤FODBCÅX°Êµ{¦¡ªº¦w¸Ë¡C
²Ä¤G¨B¡A¶i¤JVisualFoxPro¤¤¡A«Ø¥ß»P«áºÝ¸ê®Æ·½ªºÁp±µ¡C
¦]¬°Áp±µÄÝ©ó¸ê®Æ®wªº¤@³¡¤À¡A©Ò¥H¥²¶·¥ý¶i¤JVisuúQalFoxPro¡A³Ð«Ø©Î¥´¶}¤@­Ó¸ê®Æ®w¡AµM«á«Ø¥ß©R¦WÁp±µ¡]¥Î«ü¥O¡GCreateConnection£LÁp±µªº¦W¦r£N¡^¡A¦bVisualFoxPro´£¨ÑªºConnectionDesignerµøµ¡¤¤¶ñ¼g¤@¨Ç­È¤ÎÄÝ©Ê¡]¨£¤W¸`©Ò¦C¡^¡A´N§¹¦¨¤F¤@­ÓÁp±µªº«Ø¥ß¡C
²Ä¤T¨B¡A«Ø¥ß»·ºÝµø¹Ï¡C
¦]¬°»·ºÝµø¹Ï±qÅÞ¿è¤W»¡Äݩ󥻦a¸ê®Æ®wªº¤@³¡¤À¡A©Ò¥H¦b«Ø¥ß»·ºÝµø¹Ï«e¡A¥²¶·¥ý¥´¶}¸ê®Æ®w¡]¥Î©R¥O¡GOpenDatabase£L¸ê®Æ®w¦W£N¡^¡A¨Ã¶i¤J¸Ó¸ê®Æ®wªº­×§ïª¬ºA¡]¥Î©R¥O¡GModifyDatabase£L¸ê®Æ®w¦W£N¡^¡C¦bVisualFoxPro¼u¥XªºDatabaseDesignerµ¡¤f¤ºªº¤u¨ã±ø¤¤¡A¿ïÂINewRemoteView¹Ï¥Ü¡AÀH«áVisualFoxPro·|Åý§A¿ï¾Ü©R¦WÁp±µ©M»·ºÝ¸ê®Æ®w¤¤ªºªí¡F¦b§A§¹¦¨³o¨Ç¿ï¾Ü«á¡AVisualFoxPro·|¦A¼u¥X¤@­ÓViewDesignerµøµ¡¡AÅý§A¦b³o­Óµøµ¡¤¤¶i¤@¨B½T©w¡A³o­Óªí¤¤ªº­þ¨Ç¸ê®Æ¶µ¥Ø±N¥X²{¦b©Ò«Ø¥ßªº»·ºÝµø¹Ï¤¤¡C³o¨Ç¸ê®Æ¶µ¥Ø±N¦bSelectedOutput¤Uªº¦Cªí®Ø¤¤Åã¥Ü¥X¨Ó¡C
²Ä¥|¨B¡A«Ø¥ßÀ³¥Îµ{¦¡¡C
¤U­±Á|¨Ò»¡©ú«Ø¥ßÀ³¥Îµ{¦¡ªº¤èªk¡C¬°¤F»¡©ú¤è«K¡A³oùاâMSAccess¸ê®Æ®w§@¬°»·ºÝ¸ê®Æ®w¡]¿ï¨ä¥L¸ê®Æ®w®Éªº³B²z¤èªk¤Î¨BÆJ§¡¬Û¦P¡^¡A¦b¨ä¤W«Ø¥ß¤@­Ó¦W¬°workerªºªí¡A¨£¥kªí1¡C
°²©w§Ú­Ì¤w«ö¤W­z«e¤T¨Bªº¤èªk¸Ë¦n¤FODBCÅX°Êµ{¦¡¡A
¤w¥´¶}¤F¦W¬°MyDataªº¥»¦a¸ê®Æ®w¡A¨Ã«Ø¥ß¤F¦W¬°MyConªº»P»·ºÝ¸ê®Æ®wªºÁp±µ¡C
¨Ò1¡D¦b¹Ï2µøµ¡¤º¡A¬d¬Ý¾¤uª¬ªpªí¡C
§Ú­Ì»Ý­n¥ý¦b¥»¦a®w¤W«Ø¤@­Ó»·ºÝµø¹Ï¡C¥i¥H¥Î¤W­z²Ä¤T¨Bªº¤èªk¡A§â»·ºÝµø¹Ï¦W©w¬°V1¡A¦¹®É»Ý¿ï¾ÜÁp±µ¦W¬°MyCon¡C¤U­±¬OV1ªº´y­z»y¥y¡G
SELECTworker¡Dwrk¡Ðid¡Aworker¡Dwrk¡Ðname¡AworkúQer¡Dbrithday¡Aworker¡DspecialityFROMworker
µM«á¦A«Ø¤@­Óªí³æ¡]Form¡^¡A¦b¤W­±°µ¤@­ÓGrid«¬ªº¤¸¥ó¡]ª«¥ó¡^¡A§â¸Ó¤¸¥óªºRecordSourceÄݩʭȳ]¦¨V1¡C³o´N§¹¦¨¤F¤@­Ó¡]»·ºÝ¡^¾¤u¸ê°TÆ[¹îµøµ¡ªº»s§@¡C
¨Ò2¡D¦b¹Ï3©Ò¥ÜªºForm¤º¡A·í¦b¡§Â¾¤u¥N¸¹¡¨¹ïÀ³ªº¤å¥»®Ø¤º¿é¤J¤@­Ó¥N¸¹­È«á¡A´N¦b¨ä¥Lªº¤å¥»®Ø¤ºÅã¥Ü³o­Ó¾¤uªº¨ä¥L¸ê°T¡C
¥i°Ñ·Ó¤W¨Ò¤èªk«Ø¥ß»·ºÝµø¹ÏV2¡C¨ä´y­z»y¥y¬°¡G
SELECTworker¡Dwrk¡Ðid¡Aworker¡Dwrk¡Ðname¡Aworker¡Dbrithday¡Aworker¡DspecialityFROMworker¡F
WHEREworker¡Dwrk¡Ðid£M¡Hcinp
µM«á¦A«Ø¤@­ÓForm¡A°µ¦¨¹Ï3ªº¼Ë¤l¡A¦U¤å¥»®Ø¡]ª«¥ó¡^ªºControlSource¤À§O«ü©w¬°V2¡Dwrk¡Ðname¡BV2¡Dbrithday¡BV2¡Dspeciality¡C³Ì«á¦A©w¸q»P¾¤u¥N¸¹¹ïÀ³ªº¤å¥»®ØªºValid¤èªk¡Gcinp£Mthis¡Dvalus
£Mrequery¡]″V2″¡^
thisform¡Drefersh
¨Ò3¡Dª½±µ¦bµ{¦¡¤¤¨Ï¥ÎSPT¡A¬d¬Ý»·ºÝ¸ê®Æ®w¤¤ªºÂ¾¤u¸ê°T¡G
connection£MSQLCONNECT¡]¡¬MSAccessDatabasese¡¬¡A¡¬username¡¬¡^
IFconnection£N0
IFSQLEXEC¡]connection¡A¡¬select fromtable¡¬1¡A¡¬MyCursor¡¬¡^£N0
brow
ELSE
WAITWindows¡¬¤£¯à¬d¬Ý³o­Ó»·ºÝ¸ê®Æ®w¡I¡¬
ENDIF
ELSE
WaitWindows¡¬µLªk«Ø¥ßÁp±µ¡I¡¬
ENDIF

_________________
#############################
§Ö¼Ö¶ý«}¨t¦C©¯ºÖ¦v°t,³Ü¤Q¥þÂû´ö~­ì¨Ó©¯ºÖ¨º»ò²³æ!!

¾Ç·|VFP¨Ï¥ÎªÌªÀ°Ïªº·j´M,Code¤~·|§ó¦³½ì~
#############################
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
±q¤§«eªº¤å³¹¶}©lÅã¥Ü:   
µoªí·s¥DÃD   ¦^ÂÐ¥DÃD    VFP ·R¥ÎªÌªÀ°Ï ­º­¶ -> VFP °Q½×°Ï ©Ò¦³ªº®É¶¡§¡¬° ¥x¥_®É¶¡ (GMT + 8 ¤p®É)
²Ä1­¶(¦@1­¶)

 
«e©¹:  
±z µLªk ¦b³o­Óª©­±µoªí¤å³¹
±z µLªk ¦b³o­Óª©­±¦^ÂФ峹
±z µLªk ¦b³o­Óª©­±½s¿è¤å³¹
±z µLªk ¦b³o­Óª©­±§R°£¤å³¹
±z µLªk ¦b³o­Óª©­±¶i¦æ§ë²¼
±z µLªk ¦b³o­Óª©­±ªþ¥[ÀÉ®×
±z µLªk ¦b³o­Óª©­±¤U¸üÀÉ®×


Powered by phpBB © 2001, 2005 phpBB Group
¥¿Å餤¤å»y¨t¥Ñ phpbb-tw ºûÅ@»s§@