Mike Yearwood
Toronto, Ontario, Canada
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only