>How could I have Visual Foxpro display an accurate progress meter that reveals to a user the percentage of the query completed. Foxpro does this for you when it is XBase data. How do I make a progress meter when I am querying against SQL Server data?
>
>Dave.

I'm not an expert in SQL, but about the only way I can think of is

1. you need to know the number of records in the table you're querying, and then
2. add an 'and' clause to your where clause that calls a function that returns .T. In the function you would increment a counter, and put the progress bar on the screen.

Thing is, you need to know the total number of records in order to do the percentage calculation just as you do when you create any progress bar.