pcsoft.us.windevCopyright 2026, PC SOFT3 Mar 2018 11:59:15 Z28 Feb 2018 11:46:00 ZI have a Trigger Procedure and want to compare the values of a Modified record before the Trigger Procedure was called and after. The after value is no problem but the old value will have been overwritten by the new. I know there is a very easy way to do it but cannot recall how. Obviously as the Trigger Procedure is a Global procedure I cannot check any of the edit fields as they are local and not available to the global procedure. Thx in advance.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)dsprosystemspcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64793/read.awp3 Mar 2018 11:59:15 ZYou are absolutely correct Fabrice I use it in a standalone method/tool for testing, i gather every single update and have a …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64793/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64793/read.awpCompare record old and new valuesfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64771/read.awp1 Mar 2018 14:50:53 ZHi Dave, > > I managed to do it by executing a SQL SELECT query in the trigger as it > returns the record before the modifi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64771/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64771/read.awpCompare record old and new valuesdsprosystemspcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64769/read.awp1 Mar 2018 12:15:49 ZHi I managed to do it by executing a SQL SELECT query in the trigger as it returns the record before the modifications sQu…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64769/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64769/read.awpCompare record old and new valuesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64754/read.awp28 Feb 2018 13:29:00 ZJust save the record to memory and then compare the values: Declare global - ContactRec is Record of Contact In Win initiali…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64754/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64754/read.awpCompare record old and new valuesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64753/read.awp28 Feb 2018 13:20:00 ZHi John, How did you manage to do this (comparing the values) ? Regards, Jorishttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64753/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64753/read.awpCompare record old and new valuesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64752/read.awp28 Feb 2018 13:09:00 ZAll sorted. Got my memory back!https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64752/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64750-compare-record-old-and-new-values-64752/read.awpCompare record old and new values