Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
FOREIGN KEY (except for NULL) ... ?
Message
 
 
À
26/06/2008 16:53:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
01327054
Message ID:
01327057
Vues:
11
>I have a table that contains two classifications of items: products & services.
>When it is a 'service' I need to be sure that a Header record exists for it.
>To that end, I have a FOREIGN KEY on Item.HeaderID referencing Header.HeaderID.
>
>How can exclude the products, which have a NULL value in Item.HeaderID, from this FOREIGN KEY CONSTRAINT?
>
>Thanks in advance.

What is your database? SQL Server or VFP native tables?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform