Null values and foreign keys 
Author Message
 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



Mon, 05 Dec 2005 23:00:19 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Interbase:Foreign key: null value

2. Simple DBGrid Problem trying to Null out Foreign Keys

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

4. Foreign keys

5. HOWTO define foreign keys in TTable objects

6. set foreign key at run time --with interbase5.5

7. How to set foreign key to a table on run-time with PARADOX 7

8. how to set foreign key on run-time with PARADOX

9. Interbase Foreign Key question

10. primary and foreign keys

11. Replacing a foreign key ...

12. MSSQL, D3C/S: Primary --> Foreign Keys

 

 
Powered by phpBB® Forum Software