OpenEdge 11.5. From ABL or SQL connection is there a stored underlying value of when a record is created? My question is taking into consideration that the application does not have a date column in the table to store the creation date. Is there a built in value that can be accessed?
No, there is no internal or automatic record date/time stamp or entry order available.
No, there is no internal or automatic record date/time stamp or entry order available.
Flag this post as spam/abuse.
Thank you both.
> On Sep 1, 2015, at 3:12 PM, Peter Judge wrote:
>
> You could enable auditing for that, I think (ie log the creation dates). But that would only work going forward in time (ie not much help for what's currently
> created).
Way overkill.
Add a column of type datetime to hold the creation timestamp. Set the value in a trigger. But do not do this for /every/ table, just a few that matter.
Do you really need to know the creation time anyway?
Yes, of course, add a field and triggers, but that does not answer the question being asked ;)
way overkill ;-)
add a datetime field with initial now.
No answer to the OP but it might help people who are designing their db schema to take this into account.
should have remembered this yesterday:
you can have a column of type date with an initial value of today or of
type datetime with an initial value of now.
in either case, the initial value will be filled in with the current date
or datetime when you create a record.
simple, no code, no triggers, no auditing necessary.