I'm trying to define a table that has a CreateUser
column that will default to the current R:Base NAME
value.
The column appears to have the DEFAULT expression set
correctly:
CreateUser Type : TEXT 8
Default: (CVAL('NAME'))
I would expect this to put, for instance, the name
TESTING into this column (I checked and CVAL('NAME')
correctly returns TESTING at the R> Prompt).
However, what I really get is (CVAL('N which is the
first 8 characters of the expression.
The next column (CreateDate DATETIME) is defined with
the default (DATETIME(.#DATE,.#TIME)). This column is
getting a NULL Default.
Anyone know how to deal with this? I would like to
use the default technique to set these columns rather
than having to rely on an AFTER TRIGGER update.
--
Larry
