Larry,
"DEFAULT USER" is valid syntax.
USER
NULL
(value)
Default USER: Specifies the default value to be the user
identifier.
Default NULL: Specifies the default value to be null.
Default (value): Specifies the default to be the indicated
value.
Unfortunately, RBase doesnt include the additional SQL Standard
default values of CURREN_DATE, CURRENT_TIME, CURRENT_TIMESTAMP.
Perhaps in V9.0 we will see implementation of that syntax.
--- Lawrence Lustig <[EMAIL PROTECTED]> wrote:
> <<
> (IFNULL(UserNameCol,(CVAL('USER'),UserNameCol))
>
> It will then only update when it is null with the current user
> name.
> >>
>
>
> The problem with this technique is that the data does not
> survive across an UNLOAD / RELOAD. For instance, consider a
> table with two columns:
>
> (IFNULL(UserNameCol,(CVAL('USER'),UserNameCol))
> (IFNULL(UserNameCol,(.#DATE,CreateDateCol))
>
> UNLOADing and LOADing this table will result in all the user
> columns having the name of the user who reloaded the data, and
> all the columns having the date of the reload -- losing the
> original data.
> --
> Larry
>
>
>
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
