At 09:51 AM 1/23/2003 -0500, David Ebert wrote:
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?
David,
Try the following:
SET EQNULL ON
(IFNULL(EntBy,(CVAL('NetUser')),EntBy))
Very Best Regards,
Razzak.
