>>>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
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown