Re: post-change and on-validate-field trigger
From: PT <100256.3626_at_CompuServe.COM>
Date: 1995/06/17
Message-ID: <3ruinu$4c4$3_at_mhadf.production.compuserve.com>#1/1
Date: 1995/06/17
Message-ID: <3ruinu$4c4$3_at_mhadf.production.compuserve.com>#1/1
on-validate-field was a new trigger that was introduced in SQL*Forms v3.0. Before then only the POST-CHANGE trigger existed.
Since leaving the dreadful SQLFORM v2.3 behind I now never code post-change triggers. They are basically the same. However I vaguely recall that POST-CHANGE triggers do not fire if a field is NULL. ie. if you change a field from having a value to not having a value I don't think POST-CHANGE will fire but ON-VALIDATE-FIELD will.
Maybe you could test whether this is true. Hope this helps !
Phil. Received on Sat Jun 17 1995 - 00:00:00 CEST