Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Edit SQL Query with a parameter

Status
Not open for further replies.

tsoler

MIS
Jun 4, 2001
3
US
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?

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top