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?