>>Where are the rules stored for local or remote views, in the tables or in the views? If they are stored in the views then are any rules defined in the tables iqnored when an update is done? If they are stored in the views then is the only way to enter them and set other properties like FetchSize, FetchOnDemand, etc. is to use the DBSETPROP command? Is there any visual area like the properties for a table for views to change these properties?
>
>they are stored in the DBC in a binary memo field in the record dedicated for the view - you can get to them directly (remember that one Tom (s))
>but useing DBGETPROP DBSETPROP is more easy
>
>note : if by rules you mena triggers etc - these are not kept for the view at all - the underlying tables rules are the ones fired
>
>Arnon


Thanks for the response but the rules I mean are the Field rules like DEFAULT and VALIDATION stored in the DBC. Do the views which use these fields use the rules stored with the table (in the DBC)?