Originally Posted by
fatta77
From MS Access you can run the following query instead of creating a program:
UPDATE TableName SET ColumnName=0 WHERE ColumnName IS NULL
Thanks. Just added that quesry to the database and it worked perfectly.
Originally Posted by
codecarnage
I was wondering why this wasn't done in the first place.
Becuase I never knew it could be done that way....?
Originally Posted by
psybuck2002us
There are times when NULL database values represent a field better than just adding a zero or empty string.
Not in this case. The default value should be 0 (in case of entries before the date Customs instituted the Environment Fee or when the calculation called for it to be 0)
Originally Posted by
CGPGroup
I was wondering why a program was needed for this. set the default value for the column to "0", run the update query above and all is well. should not take more than 2 mins.
As above that's what I did. 0 was the default when I created the column.
I can now use this query for future new columns and/or future database tables.
.
PC - Ubuntu 15.04 64bit Desktop
HP Pav G60-236US 3GB RAM Laptop, Ubuntu 15.04 64bit and Win7 Home
"So Daddy, how come you telling me stealing not right when YOU copying DVDs? How come? How Come?"
RIP Ramesh ...