Hi Gao,

You shoud make a query and then save it. Here, FOO is your table and BAR
is the order column. The final c:\foo.tab will be sorted upon the column
value in BAR.

SELECT * FROM FOO ORDER BY BAR;

COMMIT TABLE FOO AS "C:\FOO.TAB"

Regards,
Jesús Orozco

Gao Lang wrote:

>Hi,Good evening!
>
>        Does anyone know how to order a table by rows
>"Alter Table mytable Order columnname " is only for column!      
>
>
>
>B.R
>                               
>
>Gao Lang 
>[EMAIL PROTECTED]
>2005-03-08
>
>
>
>---------------------------------------------------------------------
>List hosting provided by Directions Magazine | www.directionsmag.com |
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>Message number: 15601
>
>
>  
>


---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 15602

Reply via email to