pcsoft.us.windevCopyright 2026, PC SOFT30 Aug 2016 20:05:50 Z30 Aug 2016 11:42:17 ZHi I am using session level database table triggers. Is there a method of getting the 'before' field values of a table update within the session trigger without implementing logging? e.g. customer.name was changed from 'hello' to 'goodbye' - in the session triggers (before modify) customer.name shows as 'goodbye' - is there syntax to get the actual before value 'hello' ? Many thanks Dave30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59337-find-out-before-values-hmodify/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)fromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59337-find-out-before-values-hmodify-59348/read.awp30 Aug 2016 20:05:50 ZHi Dave, of course you can code dynamically... In fact, even simpler, you can use my code from WXReplication where I do exa…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59337-find-out-before-values-hmodify-59348/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59337-find-out-before-values-hmodify-59348/read.awpFind out before values on hModifydsprosystemspcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59337-find-out-before-values-hmodify-59346/read.awp30 Aug 2016 15:12:06 ZHi Fabrice Thanks for your reply I was hoping for some method i could do dynamically (with myfile/indirection) within the …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59337-find-out-before-values-hmodify-59346/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59337-find-out-before-values-hmodify-59346/read.awpFind out before values on hModifyfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59337-find-out-before-values-hmodify-59341/read.awp30 Aug 2016 14:29:28 ZHi Dave you can always : - create an alias on the file (halias) - read the record - get the previous valeu from the record…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59337-find-out-before-values-hmodify-59341/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59337-find-out-before-values-hmodify-59341/read.awpFind out before values on hModify