|
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¸ü.
|
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
sken
µù¥U®É¶¡: 2004-02-17 ¤å³¹: 67
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¤» ¤Q¤ë 16, 2004 1:32 pm ¤å³¹¥DÃD: ¤£¥ÎSQL SERVER ·|¦³Ô£¤U³õ???? |
|
|
¤p§Ì²{¦bªº¤½¥q¬O¥Î °Ï°ìºô¸ô ¦b¸ê®Æ®w¦s¨ú ¦ý¦Û±q§Ú¬Ý¹L±ö¤l½×¾Â©Òµoªíªº¤@½g¤å³¹,Åý§Ú¤ß²z¤ò¤òªº,¸Ô²Ó¦p¤U
*************************************************************
FoxPro¶}µoªÌ¾ÇSQL Server
Les Pinter
SQL Server²z
¦pªG§A¨Ï¥ÎDBF¨Ó¶}µoÀ³¥Îµ{¦¡¡A Á`¦³¤@¤Ñ§A·|³Qn¨D¸Ñ¨MÀ³¥ÎùØ©Ò©T¦³ªº°ÝÃD¡G¤£¦w¥þ¡]¥ô¦ó¤H³£¥i¥H¶i¤J§AªºDBF¥Ø¿ý¨Ã¬Ý±o¨£¸ê®Æ¡^¡FÀHµÛ§ó¦hªº¸ê®Æ°O¿ý¥[¤Jªí±N·|Åܱo¶V¨Ó¶VºC¡A¯S§O¬O¦b§½°ìºô(LAN)®É¡F¨Ã¥B¡A§A°¸º¸ÁÙnÃö³¬©Ò¦³¨Ï¥ÎªÌ¡A¿W¦û¶}±Ò¨C¤@Óªí¨Ã««Ø¯Á¤Þ¡C³Ì«á¡A§AªºÀ³¥Îµ{¦¡ªº¸ê®Æ¬O¤À§G¦b¦hÓÀɮסGDBF¡BFPT¡BCDX¡BDBC¡BDCX¡BDCT¡C³o¨Ï¥Îµo§G©MºÞ²z¤@ÓÀ³¥Îµ{¦¡Åܱo§xÃø¡C
¦h¨Ï¥ÎªÌÀô¹Ò¤U·|²VÂøµÛ³o¨Ç°ÝÃD¡G©Ê¯àÀHµÛªíÀɮתº¼W¤j¦Ó¤U°¡A¬O¦]¬°¯Á¤Þ¦@¨É©ó©Ò¦³³s±µªºpºâ¾÷ªº°O¾ÐÅé¡C³Ì«á¡A©Ê¯àÅܱo¬O«D±`®t¡C¥Ñ©óDBFªí¤Þµoªº¦w¥þ°ÝÃD¦b§½°ìºô¤W±N·|ÅܱoÁV¿|¡C¥ô¦ó¤H³£¥i¥H¦b¤u§@¯¸¤W¶}±Ò¸ê®Æ¡C DBFÀɮתº«e32¦ì¤¸²Õ¥ô¦ó¤@Ӧ줸²Õªº¿ù»~³£·|¾ÉPªí¤£¥iŪ¡]³o¦b²{¦b¤w¸g¤£±`µo¥Í¡A¦ý¬O§Úªº¤@¦ìªB¤Í«o¬°¦¹ªá¶O¤F³\¦h¿ú¡^¡C¦Ó¥B¡A§A±N¤£±o¤£«Ø¥ß§A¦Û¤vªº±K½X¨t²Î¨Ó±±¨î½Ö¥i¥HŪ©Îקï¸ê®Æ¡C
³q±`ªº¸Ñ¨M¿ìªk¬O¨Ï¥Îµ²ºc¤Æ¬d¸ß»y¨¥ªA°È¾¹(SQL Server)¡CSQL Server¬O¤@Ó²³æªº¾÷¨î¡A¥¦¥u¦³4±ø©R¥O(Insert¡BSelect¡BUpdate¡BDelete)¨Ã¤£Ãø¡A¥i¥H³q¹L»·µ{¸ê®Æ¶°(Remote View)©MSPT(SQL Pass-Through)¨Ó¦s¨ú¡C¦b³o®É§Ṳ́£°Q½×»·µ{¸ê®Æ¶°¡A©Î³\¥¿¦p¥¦ªº§l¤Þ¤O¡A¹ï©ó§Ú̪º¥Øªº¡A¥¦ªº°ÝÃD¤j©ó¥¦ªº©ÒÈ¡]ÁöµM¥¦¦b¸ê®Æ¾E²¾©MÂà´«®É«D±`¦³¥Î¡A§A±N¦b«á±¨£¨ì¡^¡C
*************************************************************
°ÝÃD¤@
Á`¦³¤@¤Ñ§A·|³Qn¨D¸Ñ¨MÀ³¥ÎùØ©Ò©T¦³ªº°ÝÃD¡G¤£¦w¥þ¡]¥ô¦ó¤H³£¥i¥H¶i¤J§AªºDBF¥Ø¿ý¨Ã¬Ý±o¨£¸ê®Æ)
«ç»ò¶i¤J ¨Ï¥Î³o¤S¤£ª¾ ¥D¾÷¬Oþ¤@¥x ,ª¾¹D¤S«ç»ò¬Ý ¨ä¥L¹q¸£¤S¨SÄé FOXPRO
,´Nºâ³£¦³ ¨Ï¥ÎªÌ¤]¤£ª¾¹D¬O ¦bµwºÐ¤¤ªºþ¸Ìªü(§Ú¦³ÁôÂã«,¤@¯ë³z¹L°Ï°ìºô¸ô,¬O¬Ý¤£¨ìªº)
°ÝÃD¤G
ÀHµÛ§ó¦hªº¸ê®Æ°O¿ý¥[¤Jªí±N·|Åܱo¶V¨Ó¶VºC,¯S§O¬O¦b§½°ìºô(LAN)®É
¥[¤J¦h¤Ö¸ê®Æªí¤~·|¸ûºC,¬°¦ó¬O°Ï°ìºô ?(°Ï°ìºôÀW¼e¤£¬O«Ü¤j¶Ü)
°ÝÃD¤T
¦h¨Ï¥ÎªÌÀô¹Ò¤U·|²VÂøµÛ³o¨Ç°ÝÃD¡G©Ê¯àÀHµÛªíÀɮתº¼W¤j¦Ó¤U°¡A¬O¦]¬°¯Á¤Þ¦@¨É©ó©Ò¦³³s±µªºpºâ¾÷ªº°O¾ÐÅé¡C³Ì«á¡A©Ê¯àÅܱo¬O«D±`®t¡C
¦h¨Ï¥ÎªÌ ¬O¦h¤Ö¤H ??
¯Á¤Þ¦@¨É©ó©Ò¦³³s±µªºpºâ¾÷ªº°O¾ÐÅé,¬O¥u¥D¾÷ªº°O¾ÐÅéÁÙ¬OCLIENT ºÝªº°O¾ÐÅé??
¸ê®Æ¶q¤j ,¨ì©³¬O«ü¦h¤Öµ§¸ê®Æ¤~¥s¸ê®Æ¶q¤j??
ºÃ°Ý¤@¤j°ï, ·Ð½Ð¤F¸Ñªº »¡©ú¤@¤U,·P®¦³á |
|
¦^³»ºÝ |
|
|
bin1x
µù¥U®É¶¡: 2004-08-27 ¤å³¹: 462
²Ä 2 ¼Ó
|
µoªí©ó: ¬P´Á¤» ¤Q¤ë 16, 2004 3:12 pm ¤å³¹¥DÃD: |
|
|
°ÝÃD¤G
.............
ÀHµÛ®É¶¡¹L¥h,¸ê®Æ®w¤]·|ªø¤j
¿ð¦¦³¨º»ò¤@¤Ñ,·|¦]¸ê®Æ®wªº¦¨ªø¦Ó°§C®Ä¯à
¦ýn¬Ý¸ê®Æ®wªº³]p¤W¬O«ç»ò³]pªº
¦Ó¦b¨º¨Ç§@·~¤W¤S·|¥X²{®Ä¯à°§Cªº²{¶H
·íµM¤é±`§@·~¤£¥i¯àÅý¥¦°§C®Ä¯à
¤@key ·íµM´Nn¦³¦^À³,³o¬Oµy¦³±`ÃѪº¤H¹ï¹q¸£ªº»{ÃÑ
¦ý¦pªG¬O¤@°ï¸ê®Æ,¦p¦~«×¸ê®Æ©M¦h®aÀç¹B©Ò¸ê®Æ
®Ä¯àªÖ©w¤£²z·Q
§Ú·Q¥u¯à´Â¼W¶i®Ä¯à(§Ú¬O±Ä¤À³Î¸ê®Æ®w¤è¦¡)
¦V²z·Q¤Æ«e¶i,¦ý¤£¤@©w¯à¹F¨ì²z·Qªº¹Ò¬É |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤» ¤Q¤ë 16, 2004 9:15 pm ¤å³¹¥DÃD: |
|
|
°ÝÃD¤@:
DBF ªí®æ¥»¨¤£¯à¥[±K,¦ý¬OÄæ¦ìÈ¥i¥H¦Û¤v¥[±K
°ÝÃD¤G:
¤£ºÞþ¤@ºØ¸ê®Æ®w³£·|¦]¬°¸ê®Æ¶q¹L¦h¦ÓÅܺC,³o´N±o¬Ý¯Á¤Þ¤Î¸ê®Æ®w¤ÞÀºªº³]p,¦³¨Ç³]pªº¦n,ÅܺCªº®É¶¡¿ð¤@ÂI,µL½×¦p¦ó,¤£ºÞ¨Ï¥Îþ¤@ºØ¸ê®Æ®w³£¥²¶·«ä¦Ò¸ê®Æ¶qªº¼vÅT,¥H¤Î¦p¦óÁY´î¸ê®Æ¶q,¨Ò¦p¾ú¥v¸ê®Æ²¾¥X¥D¸ê®Æªí®æ,¨Ï¥Î¸ê®Æ¥¿³W¤Æµ{§Ç,§ï¨Ï¥Î¤ë§OÀɮפ§Ãþªº.
°ÝÃD¤T:
³oºØ»¡ªk«Ü©Ç,§Ú¨SÅ¥¹L³o¼Ëªº»¡ªk,°ò¥»¤W¨S¦³¸ê®Æ®w¤ÞÀº(¨Ò¦pSQL SERVER)ªº¸ê®Æ®w,¨Ò¦pACCESS,DBF/DBCµ¥¬O¥Hclient PC¤]´N¬O¤u§@¯¸t³d§@¸ê®Æ·j´M,
©Ò¥Hclient pc ªº®Ä¯à´X¥G´Nµ¥©ó¾ãÅ骺®Ä¯à.¨Ì¦¹¬Ý¨Ó,³t«×¶VºCªº¾÷¾¹,®Ä¯à·¥¶V¦¥X²{. _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
sanchi
µù¥U®É¶¡: 2003-11-11 ¤å³¹: 61
²Ä 4 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤Q¤ë 17, 2004 12:11 am ¤å³¹¥DÃD: |
|
|
°ÝÃD¤@:Y±Ndbf©ñ¦b¥t¤@server,µM«á¥ÎSPT¥h¦s¨ú,¨ºuser´N¤£ª¾¹D¥¦¦b¦ó³B. |
|
¦^³»ºÝ |
|
|
Le1015
µù¥U®É¶¡: 2004-08-06 ¤å³¹: 30
²Ä 5 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤ë 18, 2004 2:09 pm ¤å³¹¥DÃD: |
|
|
°ÝÃD¤@ ªº[¤£¦w¥þ]À³¸Ó¥]§t(´c©ÊÃa,Del....) |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 6 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤ë 18, 2004 5:40 pm ¤å³¹¥DÃD: |
|
|
¥ô¦ó¨Æ±¡³£¦³¥¿¤Ï¨â±,
´«¤WSQL Server¤§«á,·sªº°ÝÃD¤]±N²£¥Í,
¦]¬°"¤¤¥¡¶°Åv"ªºÃö«Y,
¥ô¦ó¬d¸ß,¸ê®Æ§ó·s,¸ê®Æ³Æ¥÷,¸ê®Æ¾Þ§@¤]³£¶°¤¤¦bSQL server¤W,
©ó¬O¨Ï¥ÎªÌ¥²¶·®³¥X§ó¦hªº¿ú¥hÁʶR¨¬°÷®Ä¯àªºSQL server,
SQL server ¸ê®Æ¤jÅé¤Wºâ¬O¬Û·í¦w¥þªº,
¦ý¬O¤@¥¹·lÃa,×´_¤]¤£¤Ó®e©ö,
ÀÉ®×µ²ºcקï¤]¬O¸ûDBF¨Óªº§xÃø,
¥²¶·¨Æ¥ý·Ç³Æ¦n"¥¿½T"ªºSQL CREATE TABLE ©R¥O,
¤ñ°_DBFªº COPY STRUCTURE ¨¯W¤@ÂI,
¦pªG¥´ºâ¥H SPT ©Î¬O REMOTE VIEW ¨Ó¶}µo¨t²Î,
¨º»ò°£¤F¨ú¦^CURSORnªá®É¶¡¤§¥~,
爲¤F¼W¥[³B²z®Ä²v,ÁÙ±o爲CURSOR¥[¤WINDEX,
³o¤]¥²¶·ªá®É¶¡,
¦P®É,³oINDEX SEEK ¤@¼Ë¬O¬Ýclient ¾÷¾¹ªºµ¥¯Å,
©Ò¥H¤]¨S¬Ù¦h¤Ö®É¶¡,
¤Ï¦Ó¦h¥X¤£¤Ö¼¶¼gµ{¦¡ªº®É¶¡
ÁÙ¦³¤@¤j°ï½ÆÂøªº°ÝÃD,ÁÙ¨S´£¥X¨Ó.
¦b¨â¤T¦~«e,¤½¥q©M¨ä¥L³nÅé¼t°Ó¤@¼Ë§ë¤J¶}µo¥HSQL¬°«áºÝ¸ê®Æ®wªº¨t²Î.
¥i¬O¥Ø«e³vº¥µo²{SQL¬[ºc¦³¨ä¯ÊÂI,DBF¬[ºc¤]¦³¨äÀuÂI,
³o¬O«Ü¦h¨g±ÀSQL¬[ºcªº¤H¨S¦³»¡©ú²M·¡ªº. _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
ALLBEAUTY
µù¥U®É¶¡: 2003-08-13 ¤å³¹: 22 ¨Ó¦Û: Taiwan
²Ä 7 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤Q¤ë 18, 2004 11:36 pm ¤å³¹¥DÃD: |
|
|
¥Î¤£¥ÎSQL ServerÀ³¸Ó¬O¥ý¦Ò¼{¹B§@¼Ò¦¡§a,¦pªG¥u¬O³æ¯ÂªºLAN,©ÎªÌ»Ýn°µ¤j¶qªº¸ê®Æ¤ÀªR¹Bºâ,¨ºDBF¬O«Ü¦nªº¿ï¾Ü.
¦pªGÀç¹BÂI¬O¤Àºâ¦U¦a,³s½u³t«×¤SºC,¨º¥ÎDBF¥i¯à´N¤ñ¸û¨¯W¤F......! |
|
¦^³»ºÝ |
|
|
sken
µù¥U®É¶¡: 2004-02-17 ¤å³¹: 67
²Ä 8 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤Q¤ë 19, 2004 11:34 am ¤å³¹¥DÃD: |
|
|
¬Ý¨Ó§ÚªºÆ[©À ¦³©Ò¿ù»~Åo!
1)©Ò¥Hclient pc ªº®Ä¯à´X¥G´Nµ¥©ó¾ãÅ骺®Ä¯à.¨Ì¦¹¬Ý¨Ó,³t«×¶VºCªº¾÷¾¹,®Ä¯à·¥¶V¦¥X²{.
=> seek ì¨Ó¬O client PC ªº¤u§@ , ¥i¬O¦s©ñ¸ê®Æ®wªº¥D¾÷ ¤£´Nµ¥¯Å¤£»Ý¤Ó°ªÂP!
¨ã¤p§Ì©Òª¾
<1> client ºÝ»P server ºÝ ³s½u§@·~®É ,·|±N ¸ê®Æ ¸ü¤J¸m client ºÝªº°O¾ÐÅé(©Ò¥H§âclient ºÝªº°O¾ÐÅé¥[¤j)
<2>¦¹®É¤]·|¦û¥ÎÀW¼e(°Ïºô ¦³ 100Mbps)
<3>µ{¦¡pºâ®É,·|¨Ï¥Îclient ºÝªº¢ë¢ø¢ý¸ê·½(´£ª@client ºÝªºCPU³t«×)
<4>¼g¦^¸ê®Æ¨ìserverºÝªºµwºÐ(server ºÝªºµwºÐ¨Ï¥Îsics 320KªºµwºÐ ¨Ã§@rand 0)
2)¦pªGÀç¹BÂI¬O¤Àºâ¦U¦a,³s½u³t«×¤SºC,¨º¥ÎDBF¥i¯à´N¤ñ¸û¨¯W¤F......!
=> SQL Server ³s½u·|¥[§Ö¶Ü? |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 9 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤Q¤ë 19, 2004 1:36 pm ¤å³¹¥DÃD: |
|
|
1-tier ¬[ºc¤U,¹Bºâ«¤ß¶°¤¤¦bclient,server¥u¬O¥Î¨Ó¦s©ñ¸ê®Æªº¹êÅéÀÉ®×,
©Ò¥Hserverªº°t¸m«¦bÀɮ׶ǿ骺³t«×,¦Ó¤£«cpu®Ä¯à.
2-tier ¬[ºc¤U,¹Bºâ«¤ß²¾©¹server,¥Ñserver´£¨Ñclient¸gserver¾ã²z¹L«áªº¸ê®Æ,
client±µ¨ü³o¨Ç¸ê®Æ¤l¶°¦X«á,¦b¶i¦æ«áÄò³B²z,©Ò¥Hclientn³B²zªº¸ê®Æ¶q´NÅܤ֤F,¸û§Cµ¥¯Åªº¾÷¾¹´N¯à¹B§@.¦]¬°servert¾á¤F¸ê®Æ¹Bºâªº¤u§@,©Ò¥H¤£¦ýÀɮ׶ǿé³t«×«Ü«n,¦Û¤vserverªº¹Bºâ¯à¤O¤]«Ü«n
sanchi ¥S¤w¸g´£¥Ü¤F¦p¦ó©óWAN¤¤¨Ï¥ÎDBFªº¤èªk,¥u¬O¦¨¥»¤£¨£±o¤ñ¬[SQL server¨Óªº¦Eºâ,¤À´²¦¡¹Bºân¦Ò¼{¸ê®Æ¬y¶q,©Ò¥H¶Ç²Îªºuse dbf ,use indexªº¤è¦¡¥i¯à·|³y¦¨¸ê®Æ¬y¶q¹L¤jªº°ÝÃD,¦¹®É¬[SQLserverªº¦n³B¬O¥i¥H§Q¥ÎSQL command ¥ý¾ã²z¦¨¾A·íªº¸ê®Æ,¦A¶Ç»¼¨ì«eºÝ,¦p¦¹¥i¥H´î¤Ö¸ê®Æ¬y¶q
¤£¹L,¤]¥²¶·°t¦X¼¶¼g¦³®Ä²vªºSQL command¤~¦³³o¼Ëªº®ÄªG, _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
|
|
±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§@
|