DBMakerÀ³¥ÎÀ] §Y±N¶}¹õ

DBmakerÀ³¥ÎÀ]¬ODBMaker®a±Ú®i¥X§@«~¡B¦¨ªG¥æ¬yªº¶é¦a¡A¦pªG§A¬ODBMakerªº¨Ï¥ÎªÌ¡A¤âÃä¤]¥¿¦n¦³¤£¤Ö±o·N¨Î§@(ºô¯¸©Î¬OÀ³¥Îµ{¦¡Ãþ§O³£«ÜÅwªï³á)¡A¥i±o§â´¤¾÷·|¡A¨ìÀ³¥ÎÀ]µn¿ý®i¥Ü¦Û¤vªº±o·N¤§§@¡C¦pªG§AÁÙ¤£¬ODBMaker®a±Úªº¤@­û¡A·íµM¤]«ÜÅwªï§A¨ìÀ³¥ÎÀ]¨«¨«¬Ý¬Ý¡AÆ[¼¯§O¤Hªº¨Î§@¡A¤]¥i¥H´£ª@¦Û¤vªº³Ð·N«ü¼Æ©O¡I
­«¦^¤º®e¯Á¤Þ

DBMaker 3.7·Ç³Æ­n release Åo ¡I
¤j®a½Ð¸òD¥ý¥Í¤@°_¬Ý¬ÝDBMaker3.7 ¡y³t«×§ó§Ö¡A¤¶­±§ó¿Ë¤Á¡A¾Þ§@§ó¶¶¤â¡zªº´Î´Î·s¥\¯à... (Äò«e´Á¡K)

§ó§Ö³tªº«D¦P¨Bªí®æ½Æ»s¥\¯à
´£¨Ñ§ó§Ö³tªº«D¦P¨Bªí®æ½Æ»s¥\¯à¡A´£ª@¦bºô¸ôÀô¹Ò¤Wªº®Ä¯à¡C

§ïµ½GROUP BYªº¹Bºâ¤èªk¨Ï¹B§@³t«×§ó§Ö
´£¨Ñ¥[³t»E¦X¹Bºâ³t«×ªº¾÷¨î¡A¥H§ïµ½GROUP BY ªº¹Bºâ¤èªk¡A¨Ï¹B§@³t«×§ó§Ö¡C


§ïµ½¤l¬d¸ßªº¦h¶µ¥\¯à¡A¨Ï¬d¸ß§ó¥[§Ö³t
¬°¤F§ïµ½¤l¬d¸ßªº®Ä¯àªí²{¡A¨Ï¥Î¤F¤l¬d¸ß°õ¦æ½Õ®Õ¡A¥]¬A¤l¬d¸ß¥­©Z¤Æ¡A¥[±j³Ì¨Î¤Æ¡AÁÙ¦³ SEMI JOINªº°õ¦æ¤èªk¡A¨Ï½ÆÂøªº¤l¬d¸ßÅܲ³æ¡A³t«×§ó§Ö¡C


§ïµ½³Ì¨Î¤Æ³B²z¾¹¡A¨Ï°õ¦æ®Ä¯à§ó§Ö³t
¹ï³Ì¨Î¤Æ³B²z¾¹§@¤F¨Ç¥[±j³B²z¡A¥H§ïµ½®Ä¯à¡C


²¤Æ­««Ø¤@¯ë¯Á¤Þ¥\¯àªº¾Þ§@
¨Ï¥ÎªÌ¥iª½±µ¨Ï¥Î REBUILD INDEX ©R¥O­««Ø¤@¯ë¯Á¤Þ¡A¦ÓµL¶·¥ý DROP INDEX¡AµM«á¦ACREATE INDEX¡A¨Ï¥Î°_¨Ó¸û¬°¤è«K¡A¤]¯à°÷¦³¸û¦nªº®Ä¯à¡C


­«¦^¤º®e¯Á¤Þ

WebSearchªº«Ø¸m

¤@¯ë¤H¦b«Ø¸mºô­¶«á¡AÀHµÛºô­¶¤º®eªº¤£Â_ÂX¥R¡A¤Wºôªº¨Ï¥ÎªÌ­n¦bºô¯¸¤W§ä´M·Q­nªº¸ê°T´N·U¨Ó·U§xÃø¡A¸ÛµM³\¦hªººô¯¸·|¥Î¤ÀÃþ¡B¶¥¼h¦¡ªº¤èªk¨Ó¥[³t¨Ï¥ÎªÌªº·j´M³t«×¡A¦ý¬O¨Ï¥ÎªÌ¤´¥i¯à¤£ª¾¨ì¨ºùØ¥hÄ~Äò·j´M·Q­nªº¸ê°T¡A¦¹®É¡A³Ì¨Îªº¸Ñ¨M¤èªk¡A¬O¦bºô¯¸¤W´£¨Ñ¡uºô¯¸·j´M¡vªº¥\¯à¡AÅý¨Ï¥ÎªÌ¥i¥HÁä¤J´X­ÓÃöÁä¦r«á¡A«K¥ß§Y§ä´M¨ìºô¯¸¤Wªº¬ÛÃö¤º®e¡A¥»¤å§Y¬O¦b¤¶²Ð¡uºô¯¸·j´M¡vªº¥\¯à¡A¥D­n¬O¹ï¦Û¤v¬[³]ªººô¯¸¤W­±ªº¸ê®Æ¡A§@¥þ¤åÀ˯Á¨Ã±N¤º®e¿é¤J¦Ü¸ê®Æ®w¡A¤§«á«K¥i¥H¦bºô­¶¤¤¡A§@·j´Mªº°Ê§@¡C¦b¶i¤J¥¿ÃD«e¡A¥ý±N´ú¸Õ®Éªº¦UºØÀô¹Ò¦C¥Ü¦p¤U¡G

Web Server: Apache
PlatForm: Linpus 6.4
DBMaker: 3.7


§Ú­n¾\Ū¥þ¤å

­«¦^¤º®e¯Á¤Þ

D¥ý¥Í¦³°ÝÃD¡I

½Ð°ÝD¥ý¥Í¡ADBMaker·sª©¥»¥i¤£¥i¥H¦P®É¦s¦b,¬O§_·|¦³¤£¬Û®eªº°ÝÃD¡H


D¥ý¥Íªº¤p¯µ³Z
---
DBMakerªº¤£¦P¨t²Îª©¥»¬O¥i¥H¦P®É¨Ã¦sªº¡A¥u­n§A¦w¸Ë®É¿ï¾Ü¦w¸Ë©ó¤£¦Pªº¥Ø¿ý§Y¥i¡C ¦b¦w¸Ëªº¹Lµ{¤¤¡A±z¥i¥H¿ï¾Ü¬O§_­n§ïÅÜODBC Driver Manager¤ºÂ ª©¥»ªº¸ê®Æ®w³]©w¡C

·sª©¥»¨Ã¦s®É¡A¥²»Ýª`·N¤U¦C¨Æ¶µ¡G
  1. ·sª©¥»ªº¦øªA¾¹¨t²Î¥i¥H±Ò°Êª©¥»ªº¸ê®Æ®w¡A¥i¬O¤@¥¹¸g¥Ñ·sª©¥»±Ò°Ê«á¡A¸ê®Æ®w®æ¦¡¤wÂà´«¬°·s®æ¦¡¡A§YµLªk¦A¨Ï¥Îª©¥»¨t²Î¾Þ§@­ì¸ê®Æ®w¡C ­Y¦¹¸ê®Æ®w¬°À³¥Îµ{¦¡©Ò¨Ï¥Î®É¡A½Ð°O±o±NODBC Driver Manager¤§DSN³]©w§ó§ï¦¨·sª©¥»ªºdriver¡A¥HÁ×§K²£¥ÍµLªk¶}±Ò¸ê®Æ®wªº¿ù»~¡C
  2. ·sª©¥»ªºclientµLªk³sµ²¨ìª©¥»ªºserver¡Aª©¥»ªºclient«h¥i¥H³sµ²¨ì·sª©¥»ªºserver¡A ¦ý¬O§Ú­Ì«ØÄ³³Ì¦n±Ä¥Î¦Pª©¥»«e«áºÝ³nÅé¡C
½Ð°ÝD¥ý¥Í¡A¸ê®Æ®wµn¿ý³sµ²¼Æ¥Ø­­¨î¡H

D¥ý¥Íªº¤p¯µ³Z
---
¦bDBMaker¸ê®Æ®w¤¤¡A¦]¬°¤@­Ó³sµ²³Ì¦h¥u¯à¦³¤@­Ó¥æ©ö¡A©Ò¥H°£¤F¥H²£«~§Ç¸¹±±¨î¸ê®Æ®wµn¿ý¤H¼Æ¥~¡AÁٻݭn§Q¥Î³]©wÀɤ¤ªºDB_NTRAN°Ñ¼Æ¨Ó­­¨î¹ê»Ú¥iµn¿ý¤§¸ê®Æ®w³sµ²¼Æ¥Ø¡A¨ä¤¤DB_NTRAN¦³®Ä­È¬°¤p©ó²£«~§Ç¸¹©Ò´£¨Ñ¤§µn¿ý³sµ²¼Æ¥Ø¡C ¥Ñ©óDB_NTRAN¤§¹w³]­È¬°20,¦]¦¹§Y¨Ï§AÁʶR¤F¦h©ó20­Ó¨Ï¥ÎªÌªº²£«~ª©¥»¡A­Y¨S¦³­×§ï¹LDBMaker²ÕºAÀÉ¡]dmconfig.ini¡^ªº¸Ü¡A«h¸ê®Æ®wµn¿ý³sµ²­­¨î¤´¥u¤¹³\20­Ó¸ê®Æ®w³sµ²¡C©Ò¥H½Ð¦b§A¦b§ó·s²£«~§Ç¸¹«á°O±o¶¶«K­×§ïDB_NTRAN³o­Ó°Ñ¼Æ¡A¦p¡G DB_NTRAN = 30 ³o¼Ë§Aªº¸ê®Æ®w´N¥i¥H¦P®É¦³30­Ó³sµ²¼Æ¥Ø¡A¨Ã°O±o¦b­×§ï¹LDB_NTRAN°Ñ¼Æ«á­«·s±Ò°Ê¸ê®Æ®w¡A¥H«K¨Ï°Ñ¼Æ³]©w¥Í®Ä¡A¦p¦¹¤~¯à¯u¥¿¨Ï¥Î§ó¦hªº³sµ²¼Æ¥Ø¡C

­«¦^¤º®e¯Á¤Þ

--§¹¥þ¶}©ñµ¹¸ê®Æ®wªì¾ÇªÌªº·§©À¥R¹q¶é¦a
¥D±q¦¡¸ê®Æ®w»P¤À´²¦¡¸ê®Æ®w

¥D±q¦¡¸ê®Æ®w¬[ºc¡G
¥D±q¬[ºc¸ê®Æ®wªºÀuÂI
  1. ¸ê®Æ®w©MÀ³¥Î¨t²Î¯à°÷¨Ã¦æ³B²z¡A¥i¥H§ïµ½¨t²Î¤ÏÀ³®É¶¡©MÁ`²£¯à¡C
  2. «È¤áºÝ¾÷¾¹¥i¥H°t¦X¨Ï¥ÎªÌ»Ý¨D¡A´£¨Ñ¸û¦nªº¤¶­±¤Î¸û§Öªº¤ÏÀ³¡A¹ï¨Ï¥ÎªÌ¨Ó»¡¡A¾ãÅé¤W¤ñ¸û®e©ö¨Ï¥Î¡C
  3. ¼Æ­Ó¤£¦Pªº«È¤áºÝ¾÷¾¹¥i¥H¦s¨ú¦P¤@³¡¸ê®Æ®w¦øªA¾¹¡C¦]¦¹¡A³æ¤@¸ê®Æ®w¯à°÷³z¹L¼Æ­Ó¤£¦Pªº(¥i¯à¦b¦a²z¤W¦³«Ü¤j®t²§)«È¤áºÝ¨t²Î¦Ó³Q¦@¨É¡C

Ãö©ó¤À´²¦¡¸ê®Æ®w¬[ºc¡G

¤À´²¦¡¸ê®Æ®wÀx¦s©ó¤£¦P¹q¸£ºô¸ô¸`ÂI¤W¡A¤@¨ÇÅÞ¿è¤W¬Û¤¬ÃöÁpªº¸ê®Æ²ÎºÙ¡C

ºô¸ô¤W¦U¸`ÂI»Ý¦³¿W¥ß¦Û¥Dªº¯à¤O¡A¨Ï±o¦U¸`ÂIªº°Ï°ì¸ê®Æ®w¨t²Î¥i¤ä´©°Ï°ì¤ºªºÀ³¥Î¨t²Î¡A¦U¸`ÂIªº¸ê®Æ«h³z¹L¸ê®Æ³q°Tºô¸ô§Î¦¨Ápô¡C

¤À´²¦¡¸ê®Æ®wºÞ²z¨t²Î«h­t³dºÞ²z³o¨Ç¤À´²©ó¦U¸`ÂIªº¸ê®Æ®w¡A¨Ï±o¦U¸`ÂIªº¨Ï¥ÎªÌ¹ï¸ê®Æ¦s¨ú¤£¨ü¸ê®Æ©Ò¦b¦ì¸mªº¼vÅT¡C
­«¦^¤º®e¯Á¤Þ


~
ºÃÃøªù¶E
±¾¸¹³B

§Ú­Ì­n§ä¨ã¦³±Ð¾Ç¼ö§Õªº¡u¸ê°T§Þ³NÁ¿®v¡v 3 ¦W¥H¤W

**¬¡¤O¥R¨KªºDBMaker¤u§@¹Î¶¤¥¿¦b´M§ä¤u§@¹Ù¦ñ¡I

¤u§@¤º®e¡G±Ð±Â¹q¸£½Òµ{¡B¬ã°Q·|¥DÁ¿¡B¨ó§UDatabaseºÞ²z¬ÛÃö¨t¦C½Òµ{³]­p¤Î³W¹º
¯S®íºÖ§Q¡G¤u§@®É¶¡¼u©Ê¡BÁÙ¦³°ê¥~¥X®t¾÷·|
¥u­n§A¦³¡G¤j¾Ç¥H¤W¾Ç¾ú¡B¹ï±Ð¾Ç¤u§@¦³¿³½ì¼ö§Õ¡B¨}¦n·¾³q¨ó½Õ¯à¤O¡B»öºA¨Î¡B¦³±Ð¾Ç³Ð·N
±M·~¯à¤O¡G¼ôSQL»yªk¡B¨ã¦³¸ê®Æ®w¨t²Î¨Ï¥Î¸gÅç¡A¼ôUnix¨Ï¥Î¸gÅç
»y¨¥¯à¤O¡Gºë³q­^¤é¤åªÌÀu¥ý¦Ò¼{

**Ãö©ó DBMaker ¤u§@¹Î¶¤
¥Ñ©ó¦¨ªø¨³³t¡ADBMaker±N¦b¤µ¦~©³¤§«e¶i¦æ¤H¤OÂX½s¡A·¥±ý©Û¶Ò¦U¸ô¦n¤â¡I¦pªG §A¹ï©ó¸ê®Æ®w»â°ì©Ò¾Ç±Mªø«Ü¦³¤ß±o¡A§í©Î¬O·Q¥[¤J§Ú­Ì¡A¦¨¬°»PDBMaker¦P¥Ì¦@­Wªº¤@¥÷¤l...§Ú­Ì¸Û¼°Åwªï§A»P§Ú­Ì¤@°_¦¨ªø¡C
¤u§@¦aÂI¡G¥x¥_¥«¤K¼w¸ô2¬q260¸¹2¼Ó Ápµ¸¹q¸Ü¡G02-2741-8010 *8336

¨î«×»PºÖ§Q¡G
*¹Î«O¡B³Ò«O¡B°·«O¤T¸`¼úª÷
*°ê¤º¥~­û¤u®È¹C
*¤½¥q¤º¡B¥~±Ð¨|°V½m
*¦~¥ð°²¨î«×
*ºÖ§Q«~
*°à°s·|
*·³¥½ÁpÅw·|
*¨C¤ë¥ð¤T­Ó¶g¤»
*¥Í¤é§ª÷
*­û¤u»{ªÑ
*¥Í²£¸É§U
*¤l¤k¼ú¾Çª÷³á¡I


§A§Æ±æDBMaker¶W»Åºô¯¸·s¼W©Î¥R¹ê­þ¤è­±ªº¤º®e©Î°T®§¡H

§óÂ×´Iªº¸ê®Æ®w»â°ì§Þ³N¤å³¹
½u¤W±Ð¾Ç¸ê°T
±Ð¨|°V½m½Òµ{°T®§
DBMaker·|­ûÀu´f¬¡°Ê°T®§
§Ú¦³¨ä¥L«ØÄ³
ª© Åv Án ©ú ¥H ¤Î ¯S §O »¡©ú


Á|¤Z¥Zª«¸Ì­±¦UºØ¥ÑÃÙ§UªÌ©Ò¤ä´©ªº¤å¦r¡B¹Ï¤ù...µ¥µ¥³Ð§@¡A¥þ³¡ÂkÄÝ©ó­Ó§O³Ð§@ªÌ©Ò¦³¡A½Ð¤£­nÀH·N§@¬°¨ä¥L«¬ºAªºÂà¸ü©Î¬O°Ó·~¥Î³~³á¡I
½s¿è³¡¯S§O»¡©ú-- DBPaper°ò©ó½s¿è­Ó¤H¦]¯À¡A±N·|°±¥Z¤@¬q®É¶¡¡A·PÁ¦U¦ìŪªÌ³o´X´Á¥H¨Óªº¾\Ū»P·RÅ@¡C¦b³o¤@¬q§ïª©Â૬¡B´M§ä·s½s¿èªº¹L«×®É¶¡¸Ì¡A¦U¦ìŪªÌ®a¦pªG¦³·Q­nªí¹Fªº·N¨£©Î¨ä¥L»Ý­n¡A¤]¥i¥Hª½±µ»PDBMakerÁpµ¸¡A§Ú­Ì·|ºÉ¤v©Ò¯à¬°¦U¦ìªA°È¡C
 
 
­«¦^¤º®e¯Á¤Þ