----- Original Message -----
From: "Albert Berry" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, March 21, 2008 12:25 PM
Subject: [RBASE-L] - Re: Setting default for a column to the current user
> Larry, I just tested this. The username survives the reload, as my admittedly
> ancient memory cells reminded me. As the column is not null when the reload
> takes place, the value remains unchanged.
But the nulls don't.
> Lawrence Lustig 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
>>
>>
>>
>>
>
>
>
