Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Default values dropped from view
Message
De
02/07/2008 02:34:02
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Default values dropped from view
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01328176
Message ID:
01328176
Vues:
60
Hi All,

I have occasionally had this problem and just wanted to see if others have had similar experiences and know any reason/solutions :

For my projects I almost exclusively use views for IO. I have also use a UDF to create a unique ids for tables. I add the UDF to the default value property of the unique key for each view. Thus, when I create a new record in the view, it gets the new id which then gets written to the table when I do a tableupdate. It is then used to update/modify the values of the view when changes are made.

Every once in a while I get a call because the tableupdate is not working. When I investigate, it turns out the default value property for the unique key is empty. It seems like the DBC just loses the property value.

Everything else is fine, no table or DBC corruption, just the missing defaults.

Any ideas?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform