Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Default Values for Table fields
Message
De
15/05/2005 07:26:15
 
 
À
15/05/2005 06:38:34
Vinod Parwani
United Creations L.L.C.
Ad-Dulayl, Jordanie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01014331
Message ID:
01014333
Vues:
21
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform