>I have a fairly long (50+ lines;) SQL statement within a CASE of a method. It didn't work in the method, but worked when the exact same SQL is copied to a PRG that's called. Easy enough solution, but does anyone know why this is so?
>
>The debugger would stop in the middle of the SQL statement even when that CASE condition was skipped, as if it read something in the SQL that made it think it was the next CASE condition.
>
>TIA

I don't see what could be causing this. But as a workaround, the first thing I should try is macro substitution.

José