pcsoft.us.windevCopyright 2026, PC SOFT13 Nov 2014 10:35:00 Z8 Nov 2014 16:10:00 ZIn an application that I am developing I want to manage activity log as to when a particular data record was created, edited, etc. So for this what I did was added 6 fields to every Table/File like this: CreatedDate CreatedTime CreatedBy ModifyDate ModifyTime ModifiedBy Things are working fine till today. Now my boss says that I have to maintain a complete log in which all the activity on any table/file should be recorded. Meaning that after an entry is created I have to maintain a complete log for many times as it is edited by users so if users edit a record 15 times all the 15times entries should be recorded and for this I have to also maintain old data and new data for comparision. For this what is better way from following: Build a set of procedures that will create necessary entries in a specialized table/file and call these routines as necessary Built a set of Triggers and a few stored procedures that will do the handy work TIA Yogi Yang30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48932/read.awp13 Nov 2014 10:35:00 ZYogi check this sample of triggers it may give you some hints. http://27130.foren.mysnip.de/read.php?27131,472901,476005#msg…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48932/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48932/read.awpNeed Advise WD17 - Maintain User activity Logguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48929/read.awp13 Nov 2014 07:42:00 ZAl and Paulo, Thanks for your inputs. I think I will have to use some extra coding that will extract required data and concat…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48929/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48929/read.awpNeed Advise WD17 - Maintain User activity LogDave Langleypcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48852/read.awp9 Nov 2014 10:47:45 ZHi Yogi Keep in mind that the LOG is designed for recovery and not for the lifetime tracking of changes to data. It can easil…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48852/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48852/read.awpNeed Advise WD17 - Maintain User activity Logdavepcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48850/read.awp9 Nov 2014 05:38:18 ZKeep in mind that LOG is primarily designed for recovery and not long term tracking of changes. If LOG is ever cleared (after a …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48850/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48850/read.awpNeed Advise WD17 - Maintain User activity Logguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48849/read.awp8 Nov 2014 17:33:00 ZIf your DB is HF use the LOG for that it's the easy way. Check the log features in the help and the HHistoryModification functio…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48849/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48849/read.awpNeed Advise WD17 - Maintain User activity Logguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48848/read.awp8 Nov 2014 16:47:00 ZHello Yogi There is logging built into Windev and it will capture the changes you require, so you could have a look at it. I …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48848/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48847-need-advise-wd17-maintain-user-activity-log-48848/read.awpNeed Advise WD17 - Maintain User activity Log