Hi Rick, I was a mistype :)

Number 3 is there.

Only order is inverted and I want to index it while importing to DBF at destination,

without have to index the final table.

Moises




>>Hi
>>I am uploading data to database via SQLEXEC command, ODDBC, in phpmyadmin, MySQl database.
>>It works, but problem records are not ordered.
>>If my my table: 1,2,3,4,5...
>>Remotely it becomes: 1,2,4,5...
>
>So it's missing record 3?
>
>
>>As scan commmad treat records one by one, I can not understand why it happens.
>>Code is as below:
>

* I would suggest this condition is not being met on record number 3:
>SCAN FOR cert_pt = 0  AND lib = 1
>