Right, this gives a start for a progress bar. You would have to do a COUNT or SELECT COUNT(*) first to get the total number of records. Then, you could use that number and the counter to figure out the current percentage. Of course, all of this is going to slow down the query.

>This function uses only a counter which is updated every function call.
>I'm still looking for a solution that gives a calculated percentage of the progress.
>
>I could imaging to use the counter and to use RECCOUN(), so the function could calculate the percentage. However, RECCOUNT() does not give the number of records which will be processed, especially if DELETED() is on.
>
>
>>See Re: Progress bar for a query Thread #645831 Message #645989
>>
>>>Hello,
>>>
>>>I would like to know which function I could use to update a progress bar from an SQL SELECT statement.
>>>
>>>The progress bar works from 1 to 100 and I need to figure out the percentage of the SQL progress.
>>>
>>>Thanks for help in advance.