Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FOREIGN KEY (except for NULL) ... ?
Message
 
 
To
26/06/2008 16:53:48
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01327054
Message ID:
01327057
Views:
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?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform