>> What kind of data are yopu accessing?
>
>> Eric Kleeman
>> Austin / Samui
>
>We are accessing free Visual FoxPro tables directly off a remote file server. The tables vary widely in field type, record length and record count.
>
>...I'm not sure I have answered your question though.

You did.

The usual answer regarding SQL select progress is "no, you can't". However, you can be creative and do things like breaking up your jobs into batches. If you are worried about speed, pull the data you are working with to a local cursor or updateable view or a temporary table and use a Foxpro index, it doesn't get any faster than that. I just populated a remote table with 11 million records using inserts and 2 seeks on another 10 million record lookup table to build the SQL string. It was inserting 100,000 records every 15 minutes over a network into Sybase.

To make a long story short, if your code is optimized you shouldn't need to display a thermal or something like that unless you are doing a job that takes hours or days to complete. In FoxPro thats ALOT of records.

Btw, if you are running jobs in the Dev environment, SET MESSAGE TO is the most efficient way I have found to keep a running monitor of progress other than creating your own message window.