We are working on BAAN IV-c4 on Windows 2000 server with Oracle 9i data base. We found that in the table tdilc101 there are various records with the field "Date of Creation : crea" blank. We tried some test entries but could not simulate the same on our test server. We would like to activate the audit check for the table to track the transaction where this field remains blank.

What is the procedure to activate the audit check. What are the precautions to be taken before activating the same. And how is the process de-activated once the job is over?

Hi there,

AFAIR the procedure is rather simple:
Audit is nothing else than having the Baan database driver write logging informations to ascii files in a space saving compressed form. To evaluate these auditfiles one has to use Baan sessions. Whether audit is turned on or off is decided on database level.
You should have a database defined in Baan where audit is on, as usually all parameter tables xxyyy000 are audited.
Simply assign the table to be audited to this database, then audit information should be generated. Convert to runtime and this should be it. Switch back to the unaudited DB when audit is no longer in need.

hth

Norbert

Kamalakar

Please check the attachment, may be useful to fulfill your requirements.