Thanks to both. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Leyne, Sean Sent: Thursday, April 18, 2013 4:56 PM To: [email protected] Subject: [firebird-support] RE: Default column value not applied
Rick, > Is it because I'm explicitly trying to insert NULL for the column? As Ivan already responded, Yes The rational is that DEFAULT only applies if the column is not listed in the INSERT statement, by SQL standard. Assigning a value of NULL is a direct/positive action, so the DEFAULT does not apply. Sean ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links
