Re: Defaults in SE

} 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. 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. | +---------------------------+-----------------------------------------------+