topic Re: add time field in database table in Application Development and Automation Discussions

add time field in database table

Former Member — Tue, 19 Jun 2007 19:24:36 GMT

Hi Gurus,

I am trying to add a time field in database table. I know i can add it by using append structure.

but my problem is when records r creating in database table, the time field also populate with respective system time automatically. i think i need to use events but i have no idea how to use.

is there any other method available?

is there any system field for time stamp as date + time?

Regards

Giri

Re: add time field in database table

former_member194669 — Tue, 19 Jun 2007 19:27:38 GMT

Is this field added to a custom table?

aRs

Re: add time field in database table

Former Member — Tue, 19 Jun 2007 19:29:57 GMT

time field added to a database table.

time stamp filed added to a custom table.

Regards

Giri

Re: add time field in database table

former_member194669 — Tue, 19 Jun 2007 19:31:42 GMT

If it is custom table, then find which are programs updating that time and change and transport.

aRs

Re: add time field in database table

former_member194669 — Tue, 19 Jun 2007 19:35:32 GMT

Check for domain SYTSTP

aRs

Re: add time field in database table

Former Member — Tue, 19 Jun 2007 19:54:56 GMT

If this being updated through the table maintenance generator, you can use events.

Rob

Re: add time field in database table

Former Member — Wed, 20 Jun 2007 14:22:06 GMT

Rob,

its not updating by table maintainance generator.

I want to add Time field in table ESTDH.

when a new record updated while report version generated the time field also populate with system field.

is it possible?

can anybody help me?

Regards

Giri

Re: add time field in database table

Former Member — Wed, 20 Jun 2007 15:03:35 GMT

You need to find out which programs update this table and then find exits or BADIS where you can add the logic to do this. I don't think events will help you.

Rob