While importing, is there a way to index by ID or code at the point below, before fields are added to final DBF ?

upit="select * from certificado where exp=0 "
IF lnHandle > 0
rez=SQLEXEC(lnHandle, upit, "iCert")

So there will be no need to index my final table.

============================================================================================


>>Hi Naomi
>>
>>Yes, my table: 1,2,3,4,5...>>Remotely becomes: 1,3,2,4,5... and when I dowload records
>>back they have no order.
>>
>>I think problem is in phpmyadmin environment and not VFP or ODBC.
>>
>>I am solving the problem.
>>
>>Moises
>
>No, the "problem" is reused free space in the database.
>SQL Server reuse space that is why you get records in that order.
>As Naomi said, you should ALWAYS use ORDER BY if you want ordered record set.