>>>>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.
>CAST(pickupdate AS date) IN ( ?ld_date1, ?ld_date2, ?ld_date3) >>