Edit SQL query by parameter

[tsoler]

I've created my own complex SQL query and tested the query with hardcoded values. Now I need to substitute with parameter values and I am having difficulty modifying the query with the parameter fields. When I use the parameter fields, I get prompted from Cyrstal if I want to replace the query. If I say yes, my whole WHERE clause (complex statement) disappears. How do I keep this?

I'm using CR 7.0

Thanks