2.2.18 a) System Changes Log

Use this routine to view all changes to System tables, such as the editing, addition and deletion of records.

• To view the changed records, select a table on the grid to the left of the screen and click Search. The data are displayed on the bottom grid of the screen, where you can view the type of table change. Field Log_operacao of each table contains I of insertion, U of update and D of deletion. Press Clear to reset filters and grid records. Select a date period to search.

You can also view table fields and field types on the top grid of the screen. Next to this grid find the description of the field selected.

Procedures

You can execute the query thus:

1. In 2.2.18 a) System Changes Log.
2. Select the table you wish to view.
3. Enter the date parameter for the search.
4. Click Search.
5. View fields and references.
6. Run the query.

 

 

Query Data from this Table

This option lets you view all records of the current table selected. Though you cannot apply filters or link it.

 

Note:

Only table queries parameterized in the Tables routine are displayed.

See Also

• Tables