>>No SQL server's behavior matches with what you think as a bug. IOW SQL server allows insert if the value is null.
>>Cetin
>
>Cetin,
>
>I think you either misunderstood me or I was not clear enough. I do want to be able to insert NULLs as FK. So, the SQL Server behavior, I think, it the desired one, and it is not a bug. The VFP RI builder allows to insert NULLs (which is that I really want), but it does it because of its own internal bug. The other RI builders written by different developers either allow them or not. So far I found 3 RI builders: by Steve Sayer (do I spell his last name right?), by Walter Meester and another one by somebody from German. We installed here the first one from the list and it currently doesn't allow NULLs to be inserted. Since this one is used a lot by VFP community, it's a surprise for me that nobody complained or suggested it before.
OK maybe misunderstanding. I don't use neither VFP's or someone else's RI builder but my own.
Cetin