>>Local views are not taking default values from table fields, is there anything I'm missing to get these values from tables.
>
>View fields, like table fields have default values
>
>When you define a table you either use the default as in
>

>create table pp ;
>  (  field1   c(2) default '**' ;
>  )
>

>
>or you set them
>

>=dbsetprop('pp.Field1', 'Field', 'DefaultValue', '**')
>

>
>So you can set them with dbsetprop() for the view
>
>An alternative is to create a little program that copies the default values, format, caption, inputmask of the base tables to the view fields

Is there any generic routine available to copy these values from table to view.