Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Who should create the PK, view or table?
Message
De
12/09/2004 22:44:59
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Who should create the PK, view or table?
Divers
Thread ID:
00941514
Message ID:
00941514
Vues:
63
Hi all,

When adding records with views I don't where is the best place to create the primary key, the view or the table.
I generate the PK with a newId() function, and I don't know whether to put it on the default value of the view field or the default value of the table itself. I "have" to put the code in the table just in case I don't use the view; so I thought that if I inserted the newId() in the view I would end up creating twice the PK (and wasting PK), but I tested and it was not the case. So I don't really know what should I do from a "good practices" point of view.

TIA,
Javier.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform