You could pull the data to the client in another cursor. If it pulls completely, insert/append it to the main tables. That may take a little longer, but your indexes won't be messed up.

>To All,
>
>I have an app that is written in vfp 8. The problem that I am getting into is this, it connects to sql server to download data (using dnsless), we have a slow network and sometimes it times out. After timing out the files with indexes do not open unless I delete the index then run a re-index. Is there a way to prevent this using code or at least automatically fix the index error?
>
>Thanks.
>
>Frank