Rafael BArrios wrote:
> Description: Insert null values on a null field
>
> I have a table wich is referenced as foreing key for others, the problem is,
> in my case my table is composed of 4 fields, 2 of them are FK but all of
> them are not null by definition. If i insert the data for the FK and leave
> the other 2 empty (null), the DB accept and insert the record without any
> problem.
Can you provide definitions of both tables and and example of an insert
that should fail.
--
Richard Huxton
Archonet Ltd