Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
FOREIGN KEY (except for NULL) ... ?
Message
De
26/06/2008 17:02:47
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
01327054
Message ID:
01327059
Vues:
10
>>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?

SQL-Server 2005 SP2
Thank you,
- Frank
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform