Subject Re: Problem with query parameter
Author sdbeames
--- In, Helen Borrie <helebor@...> wrote:
> Small but crucial: use of a variable's value in a parameter is an expression, so it needs brackets:
> where CLIENTNO = coalesce((:CLIENT_NO), CLIENTNO)

Sweet! I've never known for sure what the rules are about when the brackets are required....I usually just add them until it works, but I've never had to put them around a variable alone before. Thank you (again).