>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
Gregory