>>I use TEXT to create SQL commands e.g.:
>>
>>

>>TEXT TO lc_sqlstring 
>>        select *   from hhpickup  where left(storecode,11) = ?lc_pickupstore and ( CAST(pickupdate AS date) =
>>         ?ld_date1 OR
>>         CAST(pickupdate AS date) =  ?ld_date2 OR
>>         CAST(pickupdate AS date) =  ?ld_date3)
>>         AND NOT EXISTS (SELECT idcol FROM depdetail WHERE store = hhpickup.storecode AND RIGHT(RTRIM(LTRIM(sealnumber)),7) =
>>		  RIGHT(RTRIM(LTRIM(hhpickup.sealnumber)),7)
>>         and postingdate <= ?ld_entdate)
>>         ORDER BY sealnumber
>>
>>ENDTEXT
>>

>>That worked for hundreds of thousands of different iterations but today, in one case, the text appeared on the form that was executing it. I added NOSHOW and all was well again.
>>What happened?
>
>Maybe you changed the Set Console to On? From Help: "By default, TEXT ... ENDTEXT sends output to the main Visual FoxPro window or the active window. To suppress output to the main Visual FoxPro window or the active window, issue SET CONSOLE OFF. "
>
>Anyway, I always include Noshow.
The app didn't explicitly set console off, so that probably was the issue.
It's puzzling though, that this first showed itself in this instance.
I'll include NOSHOW hereafter.