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

½Ð±Ð..ªí³æ©Ò«Øªº¯Á¤Þ©M¥Îindex on ...to ..©Ò«Øªº¯Á¤Þ.¦b¥\¥Î¤W¦³¦ó¤£¦P...

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



µù¥U®É¶¡: 2005-07-29
¤å³¹: 413


²Ä 1 ¼Ó

µoªíµoªí©ó: ¬P´Á¥| ¤E¤ë 07, 2006 6:37 pm    ¤å³¹¥DÃD: ½Ð±Ð..ªí³æ©Ò«Øªº¯Á¤Þ©M¥Îindex on ...to ..©Ò«Øªº¯Á¤Þ.¦b¥\¥Î¤W¦³¦ó¤£¦P... ¤Þ¨¥¦^ÂÐ

§Ú·Q½Ð±Ðªº¬O..¦bªí³æ¤¤©Ò«Øªº¯Á¤Þ©M¥Îindex ©Ò«Øªº©Ò¥H..¦³¦ó¤£¦P..
ªí³æ¤¤©Ò«Øªº¯Á¤Þ.·|¦]ª¬ªp¦Ó®ø¥¢¶Ü?..
¥Îindex ©Ò«Øªº¯Á¤Þ..·|²£¥Í¤@­Ó.idx¯Á¤ÞÀÉ.¦ý·|¬O¿W¤@©Ê½è..¤@©w¬O³o¼Ë¶Ü..ÁÙ¬O¥i¥H¿ï¾Ü°ß¤@¯ë©Ê½è©O?..
¦bªí³æ¤¤©Ò«Ø¥ßªº¯Á¤Þ..¥u¯à¥Îreindex­«¾ã..¦ÓµLªk­«·s«Ø¥ß¶Ü..¥Î«ü¥O¨Ó°õ¦æ..
ÁÂÁÂ..
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
garfield
Site Admin


µù¥U®É¶¡: 2003-01-30
¤å³¹: 2160


²Ä 2 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤E¤ë 08, 2006 8:58 am    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

¤@¯ë¬O¥Î index on ... tag ... ¨Ó«Ø¥ß ·|¦Û°Ê¶}±Òªº¯Á¤ÞÀÉ,
¦pªG¥Î idxÀÉ , ¤@­Óidx¥u¯à¦³¤@­Ó¯Á¤Þkey ¥B¶·­n¤â°Ê¶}±Ò,
¤£·Q¥Î reindex ¥i¥H¥ý±N index ÀÉÃö³¬,
index «á¦A¶}±Ò´Nok.

_________________
§Q¥Î>>·j´M<<ªº¥\¯à·|¤ñ°ÝªºÁÙ­n§Ö±o¨ìµª®×.
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó
syntech



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

²Ä 3 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤E¤ë 08, 2006 10:53 am    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

¬Ý¤£À´¦b»¡¤°»ò?

¤°»ò¬O"ªí³æ¤¤©Ò«Øªº¯Á¤Þ"?
°ò¥»¤Wvfp ªº¯Á¤Þ¥u¤À¬° idx ³æ¤@¯Á¤Þ(ª©¥»¬Û®e) ¤Î cdx µ²ºc¤Æ½Æ¦X¯Á¤Þ,
¨Ã¤£¨Ì¦b­þ¸Ì«Ø¥ß¦Ó¤ÀÃþ.

©Ò¥H§Ú­Ó¤H¶É¦V©ó§A»~¸Ñ¤F¯Á¤Þªº¹B§@¤è¦¡,
½Ð°Ñ¾\ Working with Tables(³B²z¸ê®Æªí®æ) ¤¤ªº Index Creation for Tables («Ø¥ß¸ê®Æ¯Á¤Þ)

_________________
¦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
liangszpt



µù¥U®É¶¡: 2004-11-18
¤å³¹: 263
¨Ó¦Û: ÆÎ东¬Ù²`¦`¥«

²Ä 4 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤E¤ë 08, 2006 2:19 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

¡H¡H¡H
请楼¥D¦A¾ã²z¤U问题¡C

_________________
§Úªº²z·Q¬O¯à¦¨为¥j¥Nªº¤@¦ì´I®a¤½¤l¡A
¤é±`¥Í¬¡´N¬O³Ü¯ù¥h©É­»°|¡A没¨Æ带þÓ¤@¯Z¤p¥´¤â¦bµó¤W调戏¨}®a妇¤k¡C
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó MSN Messenger
jtcom01



µù¥U®É¶¡: 2005-07-29
¤å³¹: 413


²Ä 5 ¼Ó

µoªíµoªí©ó: ¬P´Á¤@ ¤E¤ë 11, 2006 4:58 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

¤£¦n·N«ä..¤]³\§Ú»¡ªº¤£°÷²M·¡..¬O³o¼Ëªº..
¦b«Ø¥ß¸ê®Æªí®æ¤º¤S¤@¥\¯à¬°¯Á¤Þ..¥i¥H¦b³o«Ø¥ß³æ¤@Äæ¦ì¯Á¤Þ¤Î¦hÄæ¦ì¯Á¤Þ.¥ç¥i¿ï¾Ü¯Á¤Þ¤è¦¡..¦³¤@¯ë¯Á¤Þ.¿W¤@¯Á¤Þ.¥Dkey¯Á¤Þ...
¦ý..¤]¦³¤@¤¤¥ó¯Á¤Þªº¤è¦¡.¬O¦bµ{¦¡¤¤§Q¥Îindex on xx to xx «Ø¥ß¯Á¤Þ..
¤£À´ªº¬O..¨â¨â¤§®t²§³B..¤Î¬°¦ó¥Îindex on xx to xx ©Ò«Ø¥ßªº¯Á¤Þ¥u¯à¿W¤@¯Á¤Þ.¦]¬°¿W¤@¯Á¤Þ·|±N¬Û¦Pªº¸ê®Æ¦Û°Ê¹LÂo¦Ó¥u¥X²{¤@µ§..½Ð¦U¦ì¤j¤jÀ°¦£¸Ñµª..
ÁÂÁÂ
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
syntech



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

²Ä 6 ¼Ó

µoªíµoªí©ó: ¬P´Á¤@ ¤E¤ë 11, 2006 5:16 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

¤@ºØ¬O "µøÄ±¤Æ"ªº«Ø¥ß¤è¦¡,
¤@ºØ¬O ª½±µ¥H©R¥O«Ø¥ß .

¨âºØ¤è¦¡«Ø¥ß¥X¨Óªº³£¤@¼Ë.
®t§O¦b©ó§A¤£À´INDEX©R¥O
¥N½X:

INDEX ON eExpression TO IDXFileName | TAG TagName [OF CDXFileName]
[FOR lExpression]
[COMPACT]
[ASCENDING | DESCENDING]
[UNIQUE | CANDIDATE]
[ADDITIVE]


¦pªG§A­n«Ø ¿W¤@¯Á¤Þ
¥N½X:

INDEX ON ITEM_NO TAG ITM_IDX01 OF BOM.CDX FOR !EMPTY(ITEM_NO ) ASCENDING UNIQUE ADDTIVE


«Ø¤@¯ë¯Á¤Þ
¥N½X:

INDEX ON ITEM_NO TAG ITM_IDX02 OF BOM.CDX FOR !EMPTY(ITEM_NO ) ASCENDING  ADDTIVE


«Ø ­Ô¿ï¯Á¤Þ
¥N½X:

INDEX ON ITEM_NO TAG ITM_IDX03 OF BOM.CDX FOR !EMPTY(ITEM_NO ) ASCENDING CANDIDATE ADDTIVE

_________________
¦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
syntech



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

²Ä 7 ¼Ó

µoªíµoªí©ó: ¬P´Á¤@ ¤E¤ë 11, 2006 5:25 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

ÁÙ¬O§A§â CREATE TABLE ¸Ìªº PRIMARY KEY /UNIQUE ­þ¨Ç©R¥O »P INDEX ON ·d²V?
_________________
¦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
jtcom01



µù¥U®É¶¡: 2005-07-29
¤å³¹: 413


²Ä 8 ¼Ó

µoªíµoªí©ó: ¬P´Á¤@ ¤E¤ë 11, 2006 5:28 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

·PÁÂsyntech«ü¾É¡C¡C
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
jtcom01



µù¥U®É¶¡: 2005-07-29
¤å³¹: 413


²Ä 9 ¼Ó

µoªíµoªí©ó: ¬P´Á¤@ ¤E¤ë 11, 2006 5:30 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

¤£¬Oªº¡C¡C¬O§Ú¤£¼ôindexªº«Ø¥ß¤è¦¡¡C¡CÁÂÁ§A¡C¡C
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
jtcom01



µù¥U®É¶¡: 2005-07-29
¤å³¹: 413


²Ä 10 ¼Ó

µoªíµoªí©ó: ¬P´Á¥| ¤E¤ë 14, 2006 6:36 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

À³¥Î..¤@¯ë¯Á¤Þ
¥N½X:

INDEX ON ITEM_NO TAG ITM_IDX02 OF BOM.CDX FOR !EMPTY(ITEM_NO ) ASCENDING ADDTIVE

§Úªº¸ê®Æ¦³8µ§..
a001
a001
a001
b001
b001
a001
a001
b001
¦b©R¥O¤U°õ¦æ¤W­±ªº¤è¦¡..µ²ªG¥u³Ñ¨âµ§¸ê®Æ..
a001
b001
¤£ª¾¨º¥X¿ù..½Ð¦A«ü±Ð..
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
impotence



µù¥U®É¶¡: 2005-02-21
¤å³¹: 135
¨Ó¦Û: Hong Kong

²Ä 11 ¼Ó

µoªíµoªí©ó: ¬P´Á¤G ¤E¤ë 19, 2006 9:39 am    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

§A¦³¨S¦³ SET UNIQUE ON ?
_________________
¤@­Ó±`±`§Ñ°O Command ªº¤H !
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
jtcom01



µù¥U®É¶¡: 2005-07-29
¤å³¹: 413


²Ä 12 ¼Ó

µoªíµoªí©ó: ¬P´Á¤G ¤E¤ë 19, 2006 12:45 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

³á!¦n¹³¨S¦³..ÁÂÁ§Aªº´£¿ô..§Ú¸Õ¸Õ..¦A¦¸·PÁ©p..
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
impotence



µù¥U®É¶¡: 2005-02-21
¤å³¹: 135
¨Ó¦Û: Hong Kong

²Ä 13 ¼Ó

µoªíµoªí©ó: ¬P´Á¤T ¤E¤ë 20, 2006 10:36 am    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

§Ú¬O»¡ .... ¦pªG§A¥Î¤F set unique on ·|¥X²{¿ù»~ªºµ²ªG ....
_________________
¤@­Ó±`±`§Ñ°O Command ªº¤H !
¦^³»ºÝ
À˵ø·|­û­Ó¤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§@