>>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