DataBase table Data issue

[Former Member]

Hi Experts,

I have one custom table and I have inserted data's from one Custom program. The data's from the program stored into the table perfectly. Now the problem is after that the saved data's disappeared unknowingly.

May be the data deletion process is done by any program. Now my question is How to find the Data's of Database table getting deleted? If its done by any program How can I found that program exactly.

I was used Event trace. But there is no use.

All suggestions will he Highly Appreciated.

Thanks All.

[Former Member]

Hi,

Did you use commit work after insertion of records in your program. If not use COMMIT WORK after Inserting the records.

Regards,

Satish

[Former Member]

Do a where used list for the table and look for programs that delete.

Rob

[former_member189420]

Hi Nandini,

Have you used commit work statement in your program after uploading the data into your custom table?

Regards,

Anand Patil

[Former Member]

Thanks For all the replies. I didnt used Commit work. So I'll check it out and revert back to you.

And Rob Now im checking the Programs using where used List.

Thanks Again.

[Former Member]

There is an implicit COMMIT at the end of the program. This shouldn't be a problem.

Rob

[Former Member]

Use Tran : SCU3 to track table changes. But logging for the table needs to be activated which is done in the technical attrinutes of the Table.

Also Run report RSVTPROT .

[Former Member]

Thanks All. Using where used list I found the code and removed it. Thanks Again.