>>>Please Help:
>>>How can i make a progressbar with the thermometer control that comes in VFP50 from a multi table sql-select statements.
>>>I don't wanna use Set talk on/off to display the fp progress bar.
>>
>>Aside from SET TALK ON, the only solution I've seen to this is to add a UDF call to your SELECT statement which will contain code to update a progress bar. However, depending on the size of your SELECT (# tables, #fields, #records for SELECT to process) doing this can drastically slow down your SELECT and IMHO I wouldn't reccomend it.
>And more over I can't think of an UDF to calculate the progress percent in a multitable SQL with just one pass. I think instead a parameterized view + UDF could be a solution.
>Cetin

The problem I have with 'SET TALK ON' is NOT the progress bar but the annoying 'comments' about how many records were SELECTed by the SQL code. Inside VFP they write to the message bar at the bottom of the screen, but in an EXE they write to the screen or (much worse) to an already opened form. It might be possible to work around this by setting up a window, but that's additional overhead.