>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

You can use macro substitution in your where clause. That means that you will have to maintain the view in code instead of the view designer.

However, it sounds like it would be easier to simply build up an SQL query at run-time and use SQLEXEC() to get the data.

- Keith