> Also, it would seem to me that since the column is a
> computed column having a DEFAULT value would be an
> invalid option.
Default only comes into play when no value is entered in the row.. Having said
that, In a test table setting a default value as an expression in two
differerent datatypes, Int and text, the expression result is not displayed in
the computed column for the integer and the textual representation of the
expression is displayed in the text column as expected.
Since the bit flag for the column ("No Calculation" "AutoNum" or "Compute") is
not set to compute when you enter a value in the Default edit box, no
computation is performed.
> Jim Bentley
> American Celiac Society
> --- Jan Johansen <[EMAIL PROTECTED]> wrote:
>
