Re: Defaults in SE

alan@po.den.mmc.com (Alan Popiel) wrote: >} From: exg9537@cs.rit.edu (Edward X Garbowski) >} Subject: Defaults in SE >} Date: Mon, 24 Apr 1995 15:25:35 GMT >} Reply-To: exg9537@cs.rit.edu (Edward X Garbowski) >} Organization: Rochester Institute of Technology, Rochester, NY >} >} Hey all, I'm trying to create/alter tables so that certain >} columns will have default values. It takes the changes and >} everything, and looks like it should work...but the defaults >} are never used! >} >} Ex: have a column of char(10) with a default of user >} of column of date with default today >} >} none of the defaults work. I've tried other constraints (ie - keys, >} or checks...) and they all work. But not defaults. >} >} For reference, I'm using Informix SE 7.10 and SQL 6.01. I've also >} tried SQL 4.00 (w/ comparible SE) and it still didn't work. >} >} I find it hard to believe that Informix has never had defaults >} working....what's wrong?! >} >} thanks, >} >} ed >} -- >Defaults to constant values work. Defaults to function values, like >USER and TODAY do not work. I do not know why the use of function >defaults is not flagged as an error, since it doesn't work (as you >found out). Maybe the plan is for defaults to work with functions >in later product releases. In that case, a warning message would >still be nice. Are you saying it never worked on 6.x, 7.x or never worked at all. I have been using 5.x and I use functions extensively to create an audit table with no problems at all. Gordon Hooker gordonh@acslink.net.au Australia >Regards, >Alan >+---------------------------+-----------------------------------------------+ >| R. Alan Popiel | Internet: alan@den.mmc.com | >| Lockheed Martin, SLS | Voice: 303-977-9998 | >| P.O. Box 179, M/S 3810 | Standard disclaimers apply. Cutesy ones, too. | >| Denver, CO 80201-0179 USA | Your mileage may vary. Void where prohibited. | >+---------------------------+-----------------------------------------------+ gordonh@acslink.net.au RIPLEY, Queensland, Australia