This should be it:
(IFNULL((cval('netuser')), NULL, (cval('netuser'))))
(IFNULL(arg1,arg2,arg3))
If arg1 is null, then the value of arg2 is returned. If arg1 is not null,
the the value of arg3 is returned.
----- Original Message -----
From: "David Ebert" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 21, 2003 12:59 PM
Subject: [RBASE-L] - FW: CVAL field default
>
> I am trying to stamp each record with the network name of the user
> entering the data. I set the field (EntBy) to: (IFNULL(EntBy,
> (cval('netuser')), EntBy))
>
> What I get in the field is the above string.
>
> I use the same format for a date stamp:
> (IFNULL(Entdate, .#DATE, Entdate))
> Which works just fine.
>
> Do I need to capture the netuser value as a variable first and use the
> variable?
>
> Tia
>
> David Ebert
> Huckleberry House, Inc.
> 614-294-8097 (voice)
> 614-294-6109 (fax)
> [EMAIL PROTECTED]
>
>
>
>
