topic Re: Creating a log from custom table in Application Development and Automation Discussions

Creating a log from custom table

Former Member — Thu, 19 Mar 2009 10:34:59 GMT

Hi,

Is it possible to create log for insert, delete,update and modify data in a custom table?

If it possible, how can I rollback at the last operation?

Many thanks.

Re: Creating a log from custom table

Former Member — Thu, 19 Mar 2009 10:42:52 GMT

You need to add your custom code for this purpose. Rollback mechanism should be deviced as per your requirements since it is very user specific requirements.

Re: Creating a log from custom table

former_member404244 — Thu, 19 Mar 2009 10:44:35 GMT

Hi,

In the technical settings of the custom table u can check the cehck box for LOG.

However not sure of the rollback mechanism.

Regards,

Nagaraj

Re: Creating a log from custom table

Former Member — Thu, 19 Mar 2009 10:45:32 GMT

Hi,

You can log the changes that done on the custom table.

Steps:

1-Create the customs table.

2- Goto Techinical setting of the table

3- Check the Log Data Changes(in the bottom on the screen)

FYI...

Log data changes

The logging flag defines whether changes to the data records of a table should be logged. If logging is activated, every change (with UPDATE, DELETE) to an existing data record by a user or an application program is recorded in a log table in the database.

Note: Activating logging slows down accesses that change the table. First of all, a record must be written in the log table for each change. Secondly, many users access this log table in parallel. This could cause lock situations even though the users are working with different application tables.

Dependencies

Logging only takes place if parameter rec/client in the system profile is set correctly. Setting the flag on its own does not cause the table changes to be logged.

The existing logs can be displayed with Transaction Table history (SCU3).

With Regards,

Harinath P

Re: Creating a log from custom table

Former Member — Thu, 19 Mar 2009 10:55:45 GMT


Dependencies
Logging only takes place if parameter rec/client in the system profile is set correctly. Setting the flag on its own does not cause the table changes to be logged.

How can I do this?