>>> -- but it all depends upon the backend. I have stuff that is querying bunch of tables with over a billion records in them -- so it's going to take a sec or two no matter how well the indexes are designed and database tuning is done.
>
>Especially if your app allows customers to perform ad hoc queries; you're going to get table scans that can take many seconds or even minutes in large databases.
>
>FWIW, we tried an image control with one of those fancy rotating "working" gifs, but that also tended to freeze during ODBC querying, presumably because single-threaded VFP is set not to yield to waiting ActiveX or gifs. Perhaps the VFPX Asynchronous project has an answer; display a gif in its own thread and it should swirl merrily away. However, KG made the point that a gif that swirls attractively forever after something went bad in the query, isn't a lot of use either. I might raise it with Chuanbing to see whether VFP can be persuaded to yield via an event or whatever while it sits and waits for ODBC... the user just needs to know it's not actually stalled but working hard.

Yes that is why I used a video file. Has a globe spinning around and flashes "pulling data" --- since it's a video file in modal form the video plays. The wording of whatever you put in there can let the user know the app isn't hung.