add time field in database table

[Former Member]

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

[Former Member]

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

[former_member194669]

Is this field added to a custom table?

aRs

[Former Member]

time field added to a database table.

time stamp filed added to a custom table.

Regards

Giri

[former_member194669]

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

aRs

[former_member194669]

Check for domain SYTSTP

aRs

[Former Member]

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

Rob

[Former Member]

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

[Former Member]

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