>>Hi everybody,
>>
>>Suppose, we change one of our tables and convert datetime fields to date fields. How would we know, which views are affected by this change? If we have lots of them (~70), is there some automatic way to identify the suspects?
>>
>>Thanks a lot in advance.
>
>

cTableName = [%MyTable%]
>SET EXCLUSIVE OFF
>lcDBC = [MyDBC.DBC]
>SELECT ObjectType, ObjectName ;
>	FROM (lcDBC) A ;
>	WHERE A.ObjectType = 'View' ;
>	  AND A.ObjectID IN ;
>	  (SELECT ParentID FROM (lcDBC) B ;
>	  	WHERE LOWER(Property) LIKE ?LOWER(cTableName)) ;
>	INTO CURSOR crsAffectedViews
>

Yes, that identifies, but for changing I think doing the GENDBC would be easier to do and document then going through the dbc table.