If you need to recreate the underlying SQL of a View during runtime, then dropping and recreating Views programmatically is the only way to go. Parameterized Views only give you access to the WHERE clause.

I'm using this technique in one application and it works well.

Charlie