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...

As scan commmad treat records one by one, I can not understand why it happens.

Code is as below:

*******************************************************************

SELECT certificados

SET ORDER TO

SCAN FOR cert_pt = 0 AND lib = 1


thisform.pageframe1.page1.status.Value = "Enviando certificados...: " + ALLTRIM(Reembolso.cl)

Text to cSQL Noshow Pretext 1+2+4+8

INSERT INTO certificado
(nome,nome_cert, email,endereco,bairro,cidade,CEP,estado,telefone, CPF,horas,curso,data_curso,dt_pt_cert,code,forma_env )
VALUES (?nome, ?nome_cert,?e_mail, ?end,?bairro, ?cidade,?cep,?est,?telefone, ?cpf, ?horas,?curso,?data_curso,?dt_pt_cert,?cod,?forma_env )


ENDTEXT

asa=SQLEXEC(lnHandle,cSQL )

IF asa = 1

replace certificados.cert_pt WITH 1

DPT = DATE ()

SELECT certificados





ELSE


return

ENDIF


ENDSCAN