> > NOT NULL parameters/variables are initialized to data type default
> > value, i.e., 0 for INTEGER, etc.
>
> And 17.11.1858 for dates? :-)

This sounds illogical. There IS NO "default value" for a datatype. Period.

If you want it "not null", the either supply a custom default or raise an
exception if it properly initialized.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com