>>>Is there a way to change the SQL property of a View without first dropping it from the database and recreating it. Also, in the DE you have to close then reopen tables for it to take effect. Is there a better way?
>>>
>>>Thanx,
>>>Charlie
>>
>>Take a look at the dbsetprop function.
>>
>>
>>Wayne
>The help on DBSETPROP() indicates that the SQL property of a view is read-only. I think that means that the view has to be dropped and redefined in order to change that property.
>-Dore

Are you saying you want to change the actual select statement that defines the view?

Wayne