Hi Sebastian,

I can't help you much except to verify a couple of things for you, and hope that one of the MSFT regulars will pick up on this and take a look at it too. The 'ParameterList' view property is read-write as advertised and it's easy enough to verify with dbsetprop() and dbgetprop(). Use gendbc() or gendbcx() to verify the results, and you will see the 'ParameterList' property updated as advertised after performing a dbsetprop() on the view.

But, one of the kickers here is when you set up a view with a filter condition/where clause, something like 'State = ?lcState', either in the designer or programatically, the 'ParameterList' property is empty when queried using dbgetprop().

Another kicker is that you can add a parameter to the view defintion either in the designer from the Query/Parameters menu option or programatically as you have done, and the where clause is unaffected. In fact, if a filter condition/where clause was previously defined, it is still there.

So after reading the documentation and doing some simple tests, one would believe that there is something broke here? As far as I can tell, the 'ParameterList' property does not equate to the where clause as the documentation specifies. Clearly, the view definition can have both a where clause and a parameter list and how they are related, if at all, is the big question.

In response to your original post, I personally wouldn't do it the way you are trying. I'd lean towards SPT or redefining the view, which is simple enough to do, as a last resort. Good luck!