|
Thanks Larry and Razzak
I suspected as much but you never know unless you ask.
Paula
-------Original Message-------
Date: 08/02/04 13:25:27
Subject: [RBG7-L] - Re: Default ColumnValues
> I've never had to do this until now and should
> probably know the answer but
> can the Default value shown for a column in a table
> be an _expression_? If so
> what is the syntax?
As I just discovered last week, no, a default value
cannot be an _expression_. It must be a constant.
To put a calculated default value into a column you
must use an ON AFTER INSERT trigger.
--
Larry
| 
