Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Auditlog
Message
De
26/09/2003 11:04:48
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
26/09/2003 07:06:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00832607
Message ID:
00832703
Vues:
20
>Hi,
>I am implementing my own audit log. I get the sample from UT magazine. And I would like to enhance it to allow rollback/rollforward.

A complete commercial auditing solution already exists - I think it is called FoxAudit.

I think that database servers also have auditing capacities, usually. You might consider it as an option.

On the other hand, if you want to create your own code (based on my article, I suppose), you will have to adapt it for rollback / roll forward. Specifically, you will have to separate information into different fields: old value, new value, data type, etc.

>
>I would like to get more details about it:
>If my application open multiple database, should each database has it own table for auditlog?

That is a possibility. Another is to keep it in a single table for all database. In this case, you would need an additional field to specify the database.

Personally, I would keep the separate databases in separate directories, and keep an audit table for each one.

>Does auditlog almost "same" with replication?

I don't understand the question. Can you say it in different words?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform