View Single Post
  #3  
Old July 3rd, 2005, 07:30 AM
Santiago
external usenet poster
 
Posts: n/a
Default

Thanks Allen for taking the time to respond.

- Santiago

--
Santiago Palacios
Metalogic Software
www.metalogicsw.com
"Allen Browne" wrote in message
...
The Default Value applies only to new records.

It never has an effect on existing records.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Santiago" replytonewsgroup wrote in message
...
Hi all,
I'm adding a new column via this statement:
ALTER TABLE myTable ADD COLUMN myColumn YESNO DEFAULT YES

And it works great except that existing rows have myColumn = FALSE even
though the default is TRUE (new rows behave correctly). I would expect
that
existing rows would take on the default? Am I incorrect in my

expectation
or
is there something wrong in my SQL statement?

P.S.: If you were about to answer: Just use this statement:
UPDATE myTable SET myColumn = YES
save your breath I already have done that. The question above still
stands though.