Null values and foreign keys

Artwin

Delphi Developer

Mon, 05 Dec 2005 23:00:19 GMT

Null values and foreign keys

Hi all

Delphi5 , SqlServer2000

I have a city_id filed refers to citiea table, when i using a value from
atable no problems, any invalid value the constraints fired . and i'ts OK ,
BUT!
Why when i clear the filed 'make it null' where the constraint fied also ,
null means nothing , beause of that i can't clear filed such that ...

any help !?

TIA

Other Threads

1. Interbase:Foreign key: null value

2. Simple DBGrid Problem trying to Null out Foreign Keys

3. Foreign key allow null

4. Looking Up NULL Foreign Key

5. null in foreign key in DB2?

6. Replacing a foreign key with its value in a dbgrid

7. Modify Key Field ( when it's foreign key in another table)

8. Foreign keys and Secondary keys

9. numeric value + null = null

10. Null Values vs Defaulkt Column Value (ORACLE)