Default value doesnt work?
This is a wierd one - maybe I dont understand it (most likely)
I have 2 tables.
table 1 has a field of which a default value has been given in the design of the table.
this works perfect, so if i leave this specific field blank by default, it fills the blank value in as set in the "Default Value"
cool!
table 2 has a relationship to table 1 by ID. so table1.ID is the primary key.
in table 2 there is also another field, and as with table 1 I made a default value for this new field.
thing is, for some reason its not working. So if i leave this field blank, the "Default Value" will not kick in at all.
what am I doing wrong?
Re: Default value doesnt work?
How is your table schema written? Have you actually set a default for this field?
Regards
Re: Default value doesnt work?
Please show the db-schema (the create table scripts), the pk-fk relationships and the query that you use to test this functionality.
It should not happen as long as the relationship is not invalidated! What database server are you using?