>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
As Edward said, the SQL property is read only. The only way to change it is by recreating the view. If you going to do this, then why not just use SQL? If you need an updateable cursor, then you should look into creating a parameterized updateable view.
Erik Moore
Clientelligence