Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FOREIGN KEY (except for NULL) ... ?
Message
From
26/06/2008 17:02:47
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01327054
Message ID:
01327059
Views:
9
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform