Keith, thank you for your response. I am closing and re-opening the view. I have changed the where clause in the view designer as well as programatically, i.e. using 'create view'. This is what I want to avoid, I want to be able to modify the views parameters without re-creating the view. Unfortunately, I don't think you can change the sql code using dbsetprop - I believe it is read-only. If it were read/write that would solve my problem. But the ParameterList setting seemed like a good solution, only I can't get it to actually do anything. I am curious to know whether anyone has actually gotten this to work, and how.

Sebastian