Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
4
Erster Beitrag:
vor 7 Jahren, 7 Monaten
Letzter Beitrag:
vor 7 Jahren, 7 Monaten
Beteiligte Autoren:
Raymond Thomas, Fabrice Harari.pcs.crosspost, Milton

WD14: Hyperfile - audit trail

Startbeitrag von Raymond Thomas am 12.01.2011 07:09

Hi,

Can someone please let me know which is the best way to implement an audit trial system for my membership database. I need to keep historical details of modification to the members records ie. field old value, new value, modified by, date & time etc.

I am using Windev14 with Hyperfile classic.

Any ideas would be appreciated.

Regards
Raymond.

Antworten:

Raymond,

You would need to create another file specifically for the audit data and trigger an event on the save of a modified record to write the required data to the audit file. If you are using Groupware you can get the user name by using "gpwGetUserInfo ( gpwInfoLogin )" or if on a network you can get the user name by using "NetworkUser()"

Milton

von Milton - am 12.01.2011 20:10
Thanks Milton, I will give your suggestion a try.

von Raymond Thomas - am 13.01.2011 13:31
Hi Raymond

One solution I used for some customer is to add a memo field named
History to each file description where a trail is needed. I then created
a hModify global procedure that add in this fields the information
needed before doing the wl.hmodify

One big interest of this technique is that you can very easily add a
history TAB to your file entry form, letting anybody needing it see who
did what.

Best regards
--

Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

More information on http://www.fabriceharari.com


On 12/01/2011 07:10, Raymond Thomas wrote:
> Hi,
> Can someone please let me know which is the best way to implement an audit trial system for my membership database. I need to keep historical details of modification to the members records ie. field old value, new value, modified by, date& time etc.
> I am using Windev14 with Hyperfile classic.
> Any ideas would be appreciated.
> Regards
> Raymond.
>
Message forwarded from pcsoft.us.windev

von Fabrice Harari.pcs.crosspost - am 13.01.2011 14:35
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.