In the absence of the time to re-read a good SQL book it's discussions like this that really help in re-acquainting myself with SQL. Thanks to all of the contributors and to SAP for making this product and list available. Ralph H.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:sapdb.general-admin@;listserv.sap.com]On Behalf Of Ralf Liebenow Sent: Thursday, October 17, 2002 7:35 AM To: [EMAIL PROTECTED] Subject: Re: Possible bug in insert - empty string not allowed on coloumns with default? Hi ! There are more people out there who need a good SQL book than I thought: NULL ist _not_ "not specified". NULL is a special Value .. .. for example you can define that a column has a default value of NULL if you don't specify a value. If you wan't the DB to use the default value, you have to use the keyword DEFAULT or you just don't set it by specifing only the columns you want to set in the insert (as i wrote an example before). Ralf _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
