>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.
>
>============================================================================================
>
Why?
You never use your final table, aren't you?
You only use recordsets from it, so better index the incoming record sets instead of the whole table.
You should use indexes at the backend only when they speed yor queries.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.