>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
