Hi!
VFP built in capabilities are limited, but simple to use. You can create also your own approach for status diwplaying, but this will require some coding and diving deeper into the logic of how SQL request to remote server works.
It is not possible to show the status in complete sense of it. Assume you run a long Stored Procedure on SQL Server. Until result set is returned, you will not know about the progress of SP running on the server. You can organize this, but this will require improving of SP (to report status from inside of SP in some temporary table) and some coding at client side (to get status value from that temporary table). When you run very complex query that takes a lot of time, it is quite hard to display status of its running, if possible at all.
If you need a progress of data downloading, take a look to FAQ#8150 - you can use FetchAsNeeded option.
Hope this helps.
>How do I turn on the VFP status window
>when I execute a SQL statement?
>
>Thanks
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.