Hi:

Is it possible to change a View's SQL property on the fly? I would like to give users the capability to set the scope of their data from a form the generates a SQL string.

I'm thinking maybe a I can just change the SQL property, then requery the view.

If you can't do it this way, what is the best way to do this?

Thanx,
Charlie