|
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 |
nkjc
µù¥U®É¶¡: 2004-08-06 ¤å³¹: 5
²Ä 1 ¼Ó
|
µ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 |
|
¦^³»ºÝ |
|
|
garfield Site Admin
µù¥U®É¶¡: 2003-01-30 ¤å³¹: 2158
²Ä 2 ¼Ó
|
µ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¨ìµª®×. |
|
¦^³»ºÝ |
|
|
goto-dream
µù¥U®É¶¡: 2004-05-11 ¤å³¹: 909
²Ä 3 ¼Ó
|
µ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³£·|¦³¦³´yz.
ºô¸ô¤Ó¦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§@¹Ú |
|
¦^³»ºÝ |
|
|
|
|
±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§@
|