Set all values in new record to default value to avoid NULL
Posted on 2008-10-07
I have a table with over 200 fields.
Fields are characters, decimals, bits, dates, etc
When I am adding new record to a table, I am inserting data for 10 fields. Other 190 fields get NULL value after new record is added/saved.
I wanted to set other 190 fields to their defualt blank values.
for example: if data is character I want to to get empty string value " ".
all decimals to get 0 value
all bits to get 0 value
dates to be blank dates, etc
What is a query / code that I can use to achieve this?