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

³t«×ÅܺC¤F

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



µù¥U®É¶¡: 2004-12-01
¤å³¹: 64
¨Ó¦Û: ¥x¤¤

²Ä 1 ¼Ó

µoªíµoªí©ó: ¬P´Á¤T ¤Q¤@¤ë 28, 2018 3:56 pm    ¤å³¹¥DÃD: ³t«×ÅܺC¤F ¤Þ¨¥¦^ÂÐ

½Ð°Ý¦U¦ì¤j¤j,¦b¬d¸ß¸ê®Æ®w®É,¦³®ÉÅܺC¤F,°h¨ì®à­±­«¶iµ{¦¡,¦A¬d¸ß¤@¦¸¤SÅܧ֤F,¨Ï¥Î¤@°}¤l«á.¤SÅܺC¤F,¦³¤j¤j¸I¹L³o¬O¤°»òª¬ªp¶Ü?¥i§_¤£§[«ü±Ð
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
CPS0204



µù¥U®É¶¡: 2014-08-24
¤å³¹: 441


²Ä 2 ¼Ó

µoªíµoªí©ó: ¬P´Á¤T ¤Q¤@¤ë 28, 2018 4:03 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

½Ð°Ý§A¬O VFOXPROªºDBF,©Î¬OSQL SERVER?
³æ¾÷©Î¬O¦³¥t¥~¤@¥xªº SERVER
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
andybigbos



µù¥U®É¶¡: 2004-12-01
¤å³¹: 64
¨Ó¦Û: ¥x¤¤

²Ä 3 ¼Ó

µoªíµoªí©ó: ¬P´Á¤T ¤Q¤@¤ë 28, 2018 4:07 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

VFP + DBF + ºô¸ôºÏºÐ¾÷¨Ï¥Î
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
CPS0204



µù¥U®É¶¡: 2014-08-24
¤å³¹: 441


²Ä 4 ¼Ó

µoªíµoªí©ó: ¬P´Á¤T ¤Q¤@¤ë 28, 2018 5:29 pm    ¤å³¹¥DÃD: §Ú·Q ¤Þ¨¥¦^ÂÐ

1.§Ú·QÀ³¸Ó¥X¦bºô¸ô¤À¨Éªº±±¨îÅv¤W­± (WINDOWS ¼h­±
2.©Î¬O¬d¸ßDBF ¬O±N­ì¥»SERVERªºDBF COPY ¦Ü¥»¾÷ªºRAM¤¤¹Bºâ,·íÀɮפj©ó§AªºPCªº°O»õÅé®É,·|¦s¤J§Aªº¥»¾÷µwºÐ!³y¦¨ÅܺC,©Î¬O,¬d¸ß®É¦³¨ä¥Lºô¤Í¦bÂê©wÀɮשÎRECORD¶i¦æLOCK,UNLOCK.........©Ò¥H§Aªº°Ê§@¥²»Ýµ¥¤@¤U

3.©Î¬OWINDOWS cache memory ¾÷¨î¤W

1/2/3³£¦³¥i¯à
«Øij:§ï¥ÎSQL SERVER,100% ¨S°ÝÃD,¥B³t«×§Ö100­¿¥H¤W!
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
ezpos



µù¥U®É¶¡: 2011-04-20
¤å³¹: 323


²Ä 5 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤Q¤@¤ë 30, 2018 6:51 pm    ¤å³¹¥DÃD: Re: §Ú·Q ¤Þ¨¥¦^ÂÐ

CPS0204 ¼g¨ì:
1.§Ú·QÀ³¸Ó¥X¦bºô¸ô¤À¨Éªº±±¨îÅv¤W­± (WINDOWS ¼h­±
2.©Î¬O¬d¸ßDBF ¬O±N­ì¥»SERVERªºDBF COPY ¦Ü¥»¾÷ªºRAM¤¤¹Bºâ,·íÀɮפj©ó§AªºPCªº°O»õÅé®É,·|¦s¤J§Aªº¥»¾÷µwºÐ!³y¦¨ÅܺC,©Î¬O,¬d¸ß®É¦³¨ä¥Lºô¤Í¦bÂê©wÀɮשÎRECORD¶i¦æLOCK,UNLOCK.........©Ò¥H§Aªº°Ê§@¥²»Ýµ¥¤@¤U

3.©Î¬OWINDOWS cache memory ¾÷¨î¤W

1/2/3³£¦³¥i¯à
«Øij:§ï¥ÎSQL SERVER,100% ¨S°ÝÃD,¥B³t«×§Ö100­¿¥H¤W!


¤j¤j
SQLServer¦p¦ó¥[§Ö³t«×

_________________
ezPos¦¬»È¾÷ ²³æ¦n¥Î§C¦¨¥» http://www.ezpos.info
¥þ·s¬üÆ[ªºPOS¦¬»È¾÷.POS³nµwÅé¯Ó§÷.
³nÅé«È¨î¤Æ.ºô¯¸³W¹º....¯àÁÈ¿úªº³£¥i¥H§ä§Ú

http://www.twelife.com ¥xÆW¥Í¬¡ºô
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ °ÑÆ[µoªí¤Hªº­Ó¤Hºô¯¸
CPS0204



µù¥U®É¶¡: 2014-08-24
¤å³¹: 441


²Ä 6 ¼Ó

µoªíµoªí©ó: ¬P´Á¤» ¤Q¤G¤ë 01, 2018 8:43 am    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

¤j¤j
SQLServer¦p¦ó¥[§Ö³t«×
***********************************
1.dbf ªº SELECT * °µªk¬O±Nºô¸ôªÚ¾FªºDBF COPY ¦Ü§AªºRAM(DISK)µM«á¦b¥Ñ¤º³¡¥h¿z¿ï,­Y¦³100MB,COPY´N­n5-10¬í
2. SQL SERVER ªº SELECT * ,¥u¶Ç¦^§A¿z¿ïªº¸ê®Æ,¨Ò: 100¸Uµ§,¥u¦³3µ§²Å¦X,¶Ç¦^3µ§, 0.00001¬í¤£¨ì
©Ò¥H·|¥[§Ö«Ü¦h,¦³®É¤£¥u100­¿
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
ezpos



µù¥U®É¶¡: 2011-04-20
¤å³¹: 323


²Ä 7 ¼Ó

µoªíµoªí©ó: ¬P´Á¤» ¤Q¤G¤ë 01, 2018 10:58 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

§Ú·Q»¡¤@¸Uµ§¸ê®Æ¦p¦ó¥[§Ö³t«×!!
­ì¨Ó¬Oselect ¥[¤Wwhere

_________________
ezPos¦¬»È¾÷ ²³æ¦n¥Î§C¦¨¥» http://www.ezpos.info
¥þ·s¬üÆ[ªºPOS¦¬»È¾÷.POS³nµwÅé¯Ó§÷.
³nÅé«È¨î¤Æ.ºô¯¸³W¹º....¯àÁÈ¿úªº³£¥i¥H§ä§Ú

http://www.twelife.com ¥xÆW¥Í¬¡ºô
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ °ÑÆ[µoªí¤Hªº­Ó¤Hºô¯¸
CPS0204



µù¥U®É¶¡: 2014-08-24
¤å³¹: 441


²Ä 8 ¼Ó

µoªíµoªí©ó: ¬P´Á¥| ¤Q¤G¤ë 06, 2018 6:09 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

§Ú·Q»¡¤@¸Uµ§¸ê®Æ¦p¦ó¥[§Ö³t«×!!
­ì¨Ó¬Oselect ¥[¤Wwhere
*************************
¾A·íªºµ¹SQL SERVER TABLE ¥[¤W¯Á¤ÞÁä,·|§ó¥[§Ö¬d¸ß³t«×
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
ckp6250



µù¥U®É¶¡: 2004-07-30
¤å³¹: 1642


²Ä 9 ¼Ó

µoªíµoªí©ó: ¬P´Á¤@ ¤Q¤G¤ë 10, 2018 4:51 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

§Ú»{¬°¡A°ÝÃD¤£¬O¥X¦b¡i ºô¸ôºÏºÐ¾÷¡j
§Ú´ú¸Õ¤Fºô¸ôºÏºÐ¾÷¤Wªº¤@­Ó dbf , ¦³ 227 ¸Uµ§¡A
§Ú¤U¤F¡@select * from xxx where xxx
¼´¦^¤F14000µ§¡A¤]¥u­n0.03¬í
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ °ÑÆ[µoªí¤Hªº­Ó¤Hºô¯¸
akwang



µù¥U®É¶¡: 2004-11-06
¤å³¹: 24
¨Ó¦Û: ccf

²Ä 10 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤@¤ë 11, 2019 9:19 am    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

这个问题¦Pý©§xÊð§Ú«Ü¤[¤F
DBF©ñ¦bªA务¾¹¨½¡A¤å¥ó夹¦@¨Éªº¤è¦¡
¥u¦³1个«È户ºÝµn录¾Þ§@没问题¡A¦³²Ä¤G个«È户ºÝµn录¦Z开©l变ºC¡C¡C¡C¡C
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
syntech



µù¥U®É¶¡: 2003-05-16
¤å³¹: 4211
¨Ó¦Û: Taipei,Taiwan

²Ä 11 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤@¤ë 11, 2019 10:57 am    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

³o­Ó°ÝÃD±q¦³dbf´N¥X²{¤F.
©Ò¥H¤~·|¾É¤J sql server ªºclient-server ¬[ºc
·íµM¥i¥H¥hgoogle¤@¨Ç¤åÄm.

¦pªG¤£¨Ï¥Î sql server,
¨º´N­n¤p¤ß³]­p¸ê®Æ¦s¨úªº¤è¦¡,
¦h¥Îindex seek,
¤Ö¥Î·|Åܦ¨ table scanªº locate,filter µ¥µ¥,

¤@¥¹¶i¤J table scan ,
¸ê®Æ³B²z½d³ò´NÅܦ¨¾ã­Ótable,
³t«×´NºC¤F.

sql ³B²z¬O¤@­Ó¦n¿ìªk,
¥H«e°Q½×¹L,
sql ³B²z³t«×¨ä¹ê¤ñ·Q¹³¤¤§Ö±o¦h.
¤£¹L¤]¥i¯à§óºC,
­n¦h¦h½m²ß,
¤~¯à´x´¤sql»P¶Ç²Î©R¥O¬Û³Bªº§Þ¥©

_________________
¦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¦£
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó AIM Address
±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§@