>I’m using VFP8 / SQL Server 2000. I have an animated GIF progress bar control on my form. I’m trying to start the gif, call the SQL procedure and stop it when SQL call is completed.
>
>The problem is that the animation stops when the SQL call starts. Can that we corrected?
>How do you get around this?
Is this while you're under development? I'm assuming that you're running SQL Server on your own machine in this case. I've noticed that animated gifs will freeze during processes that consume a lot of CPU are going on. Presumably, you won't be running SQL Server on the same machine that's showing the animated gif when you're running in production, so that won't be a problem.