Re: Not null field with default value

[Tom Byars]

Jay, thanks for your time but I'm not clear what your point is. If I allow the field to have a null value then null is a legal value so under what circumstances is the default value assigned to the field? It seems from what you've done above that the default value is only written to fields where DEFAULT is explicitly stated. Why not just write the actual default value rather than DEFAULT.

It reminds me of that bit in Monty Python and the Holy Grail when they find a skeleton in a cave and scrolled on the wall next to it is a message "The holy Grail can be found at the castle of aaaaarrrrrgggghhhhh". Someone says he must have died while he was writing it. Someone else says "well why didn't he just write the name of the castle instead of aaaaarrrrrgggghhhhh". Someone else suggests he might have been dictating.