<< Can someone tell me how/if the View Parameters menu option works when modifying a view? I know you can specifiy parameters using the ? in the 'where clause', but I would like to be able to alter the parameters using the dbsetprop('ParameterList') function. When I add parameters into the list, they don't seem to do anything, even if I use them in the 'where clause' it doesn't seem to matter if they are on the list or not. Any ideas or suggestion would be greatly appreciated. >>

Seems like you might be better off with SPT if you need to dynamically change view parameters the way you're indicating.

Using SQL pass thru would probably allow you greater flexibility and might even be more robust.

Maybe you can explain to us why you would choose to modify the view using dbsetprop()? Maybe there's something going on that I don't understand.