Oradb wrote:If Insert Processing works well, then why are you here asking about it.
I created a table have 3 columns. one column is PK and other column set default as 0.
create table test
id NUMBER(12) not null,
salary NUMBER(10,2) default 0.00,
hour NUMBER(10,2) default 0.00
when user insert value at MS access form. salary and hours are blank. insert processing works well.
But salary and hour column is null. default value 0.00 does not be put into column during inserted data.How do I ask a question on the forums?
We use oracle 11.2 at window 64 bit 2008.
the default values will be ignored and both SALARY and HOUR will be NULL. If Access generates a statement
INSERT INTO test( id, salary, hour ) VALUES( 1, null, null )
the default values will be used for both SALARY and HOUR. If you are observing the both are NULL, that strongly implies that Access is generating a SQL statement that includes all three columns.
INSERT INTO test( id ) VALUES( 1 )
Oradb wrote:Are you saying Access doesn't display 0.00?
Thanks for your help!
ID exist at test table but salary and/ or hour column is null if front MS Access form field is blank and pass a null value.
select id, nvl(salary,'NULL SALARY') nvl(hour,'NULL HOUR') from test;