FoxPro/Visual FoxPro - Ordenar registros en tabla

USE LIS_ADE IN O EXCLUSIVE

SELECT LIS_ADE

INDEX ON NUM_PAG TAG IPAG

INDEX ON NUM_ITE TAG IITE

INDEX ON NUM_ELE TAG IELE

INDEX ON APE_MAT TAG IAPEMAT

INDEX ON APE_MAT TAG IAPEPAT

USE

USE LIS_ADE IN 0 SHARED

SELECT * FROM LIS_ADE WHERE NUM_PAG BETWEEN 800 AND 899 INTO CURSOR CURLISADE READWRITE

SELECT CURLISADE

INDEX on STR(num_pag,6,0)+STR(num_ite,2,0) TAG iPagIte

SELECT CURLISADE

GO TOP

BROWSE

<proc name="get_table_info">

	<table name="C:\THEODORE\TEMP\lis_ade9.dbf">

		<filetype>Tabla de Visual Fox Pro</filetype>

		<size>1975869</size>

		<header_records>14965</header_records>

		<header_size>488</header_size>

		<record_size>132</record_size>

		<cdx_memo>0-Ninguna</cdx_memo>

		<calculate_records>14965</calculate_records>

		<fields_count>6</fields_count>

		<database>Free_Table</database>

		<field_list>

			<field name="NUM_PAG"><type>N</type><lenght>6</lenght><decim>0</decim></field>

			<field name="NUM_ITE"><type>N</type><lenght>2</lenght><decim>0</decim></field>

			<field name="NUM_ELE"><type>C</type><lenght>8</lenght><decim>0</decim></field>

			<field name="APE_PAT"><type>C</type><lenght>40</lenght><decim>0</decim></field>

			<field name="APE_MAT"><type>C</type><lenght>40</lenght><decim>0</decim></field>

			<field name="NOM_ADE"><type>C</type><lenght>35</lenght><decim>0</decim></field>

		</field_list>

	</table>

</proc>