David,
I sent this on the 21st.
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
----- Original Message -----
From: "David Ebert" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, January 23, 2003 9:51 AM
Subject: [RBASE-L] - Default field value CVAL
> 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.
> [EMAIL PROTECTED]
>
>
>
>
