There is no way to get progress indicator for SQL exection. Same things applies to TOTOL, REPLACE etc. If it is not a COM DLL, you can turn SET TALK to ON and VFP will display the Progress Bar. You can easily determine progress using SCAN because you know total # of records ahead of time. If reporting progress is very important, you can wrap REPLACE and TOTAL inside SCAN..ENDSCAN. It will be a bit slower though...


>I have created a VFP7 COM DLL that creates data for a report. You set some
>properties and call the StartReport method, and when it's done, it returns
>the full path and name of the table created.
>
>In the process of creating the data, I do some SQL's, SCAN and REPLACES,
>TOTAL's and other data manipulation to get the table ready.
>
>Here's the question:
>
>I want to be able to report back the status, preferably in a status bar, to
>the client application.
>
>To accomplish this, I created 2 properties called oCallBackObj anc cCallBackFunc
>which contain an object reference to the object which will do the reporting
>and the name of the funtion to call.
>
>The question is; how to I determine the percent done of a SQL command? And then
>how do I determine the total percent completed? To clarify, there are
>many steps involved in preparing the data. First some SQL's, the some SCANs,
>and a TOTAL command.
>
>It would be nice to simply call the ReportStatus method, passing a percent done,
>and have that percent represent the total percent done, including SQL's, SCANs
>and so forth.
>
>Any ideas?