Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Default Values for Table fields
Message
From
15/05/2005 07:26:15
 
 
To
15/05/2005 06:38:34
Vinod Parwani
United Creations L.L.C.
Ad-Dulayl, Jordan
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01014331
Message ID:
01014333
Views:
20
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform