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

order by °ÝÃD

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



µù¥U®É¶¡: 2004-08-06
¤å³¹: 5


²Ä 1 ¼Ó

µoªíµoªí©ó: ¬P´Á¤» ¤K¤ë 07, 2004 8:22 am    ¤å³¹¥DÃD: order by °ÝÃD ¤Þ¨¥¦^ÂÐ

½Ð°Ý¦U¦ì¦b¤Uorder by «ü¥Oªº®É­Ô¦p¦ó¥i¥H¥Ñ¤j±Æ¨ì¤p?
ÁÂÁ¤j®a
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
garfield
Site Admin


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


²Ä 2 ¼Ó

µoªíµoªí©ó: ¬P´Á¤» ¤K¤ë 07, 2004 10:45 am    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

³o»ò²³æªº°ÝÃD¬°¤°»ò¤£¦Û¤v¥h¬d help
¥h·L³nºô¯¸¤U¸üVFP9 ¤]¦³¤º§tHELP.

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



µù¥U®É¶¡: 2004-05-11
¤å³¹: 909


²Ä 3 ¼Ó

µoªíµoªí©ó: ¬P´Á¤» ¤K¤ë 07, 2004 4:08 pm    ¤å³¹¥DÃD: Re: order by °ÝÃD ¤Þ¨¥¦^ÂÐ

nkjc ¼g¨ì:
½Ð°Ý¦U¦ì¦b¤Uorder by «ü¥Oªº®É­Ô¦p¦ó¥i¥H¥Ñ¤j±Æ¨ì¤p?
ÁÂÁ¤j®a


³o»ò²³æªº°ÝÃD.ÀH«K§ä¥»¤Jªù®Ñ.
©Î¥h§äSQL«ü¥O³£·|¦³¦³´y­z.

ºô¸ô¤Ó¦h¤p¥Õ¤F.¥u·Q¾ßÂI²{¦¨ªº.
¤ßºA¤£§ï.¤£¦p¥h³ÁÂû±Æ¦nÁÈ~~

¥H¤UHelp¤Wªº»yªkÂà¶Kªº¡G
¥N½X:

Order By Order_Item [ASC | DESC]
®ÚÕu¦Cªº‡ÛÕu†Á¬d†R…CªG…n¦æ±Æ§Ç¡C¨Cƒª Order_Item ³£¥²…§†Á‰Ø¬d†R…CªG¤¤ªº¤@¦C¡C¥¦¥i¥H¬O¤U¦C¤§¤@:
FROM ¤l¥y¤¤ªíªº¦r¬q¡A¦Pƒº¤]¬O SELECT ¥D¥y(¤£¦b¤l¬d†R¤¤)ªº¤@ƒª‰uˆá…¥¡C
¤@ƒª‡Û­Èªí†c¦¡¡Aªí¥Ü¬d†R…CªG¤¤¦Cªº¦ì¸m(³Ì¥ª‹Ê¦CˆC†Aƒo 1 )¡C
ASC «ü©w¬d†R…CªG®ÚÕu±Æ§Ç…¥¥H¤É§Ç±Æ¦C¡C¥¦¬O ORDER BY ªºÀq‡P‰u…¥¡C

DESC «ü©w¬d†R…CªG¥H­°§Ç±Æ¦C¡C

_________________
ºÖ¶©©÷²b¤ô¦³­­¤½¥q--²b¤ô¾¹ªº±M®a,²b¤ô¾¹,¶¼¤ô¾÷,Âo¤ß!!

·Q¤F¸Ñ§ó¦h¡A±z¥i¤W©¯ºÖÂû´ö²Õ.§ä´M!!¤BæXÞ±.¦Ñ®v.

¡@¡@¡@¡@¡@¡@¡@¡@¡@¡@·R§@¹Ú
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó
±q¤§«eªº¤å³¹¶}©lÅã¥Ü:   
µoªí·s¥DÃD   ¦^ÂÐ¥DÃD    VFP ·R¥ÎªÌªÀ°Ï ­º­¶ -> SQL °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§@