>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