"Created by" system maintained field (@cb)

[Jose Lerebours]

Kenneth Brody wrote:
> Del wrote:
>   
>> @cb is the "created by" field maintained by filepro for every record in a database.
>> One of my users is complaining that when he modifies an existing record created by someone else, it changes the "created by" id to his id, when it should only change @ud (updated by).
>> This is an order entry application and these fields are important to the way they track things.
>> Has anybody else seen this happen?  I thought this field (@cb) would never change once the record is created.  He also reports the @cd (created date) does NOT change.
>> Of course, I have not seen this happen myself, and he admits that it only happens occasionally, not every time, so maybe there is another explanation?
>>     
>
> filePro will only set @CB and @UB when creating a new record.  In the over 
> 25 years since Profile/filePro first came out, I do not recall ever having 
> heard of it doing otherwise.
>
> If it only happens "occasionally", I would suspect that on those 
> "occasions", the user has, in fact, deleted and recreated a new record, and 
> not updated an existing record.  Is there any pattern?
>
>   
I would like to second Ken's point on that it is possible that the 
record is being delete/recreated.  Even if the user does not know he/she 
is doing this, the program itself may be.

Regards,

Jose Lerebours
954-559-7186
http://www.fpgroups.com