Re: Date/Time fields in DB file

[mlazarus <mlazarus@xxxxxxxxxxxx>]

Greg,

 If the date/time/timestamp fields are *NOT* defined in the RPG program 
and a record is added, it will automatically contain the current 
date/time value instead of the *Loval values.  The way to do that is to 
create a LF or view that does not contain those fields, but only 
contains the original fields, without the date/time fields.  The easiest 
way to accomplish this with an existing application (IMHO) is to rename 
the original PF to a new name and name the new LF/view the original 
name.  That way, no application changes are required.

 -mark

On 8/10/2023 1:57 PM, Greg Wilburn wrote:
> I recently added an ISO date and ISO time field to an existing database file (DDS).  This file is populated by our TrustedLink EDI software when we receive an inbound PO.  I guess I had hoped it would capture the date/time the record was created.  Tli support says the EDI translator won't update those "automatically".
>
> Anyone know of a method of getting these fields to update with current info upon creation?  Otherwise, I'll have to update them in my RPG processing program.
>
> TIA,
> Greg
> [Logo]<https://www.totalbizfulfillment.com/>     Greg Wilburn
> Director of IT
> 301.895.3792 ext. 1231
> 301.895.3895 direct
> gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
> 1 Corporate Dr
> Grantsville, MD 21536
>