>I've opted to use "set talk on" to display VFP's native progress bar but I can't suppress the message that displays how many records were retrieved and the elapsed time. Example:
>
>SET TALK ON
>select street,hydrant,miles ;
> from firemain ;
> where blah blah blah ;
> into cursor mycursor
>SET TALK OFF
>
>After query completes the message "selected # records in # seconds" appears on my form and covers up some controls...very messy.
>
>Also, I have some longer queries that have UNION statements in them. Is there a way to only show one progress bar that starts when the first select fires and ends after the entire query is complete even if there are union statements involved?
>
>Thanks,
>
>John
John,
Either keep the STATUS bar on (not pratical) or I'd suggest activating a dummy non-visible window before you run the SQL to catch any unwanted text display.
HTH
regards
Ian