Problem with NULL in LOV
From: <ppiotrowski_at_riag.com>
Date: Tue, 18 May 1999 19:50:04 GMT
Message-ID: <3741c3a3.12589723_at_news.int.westgroup.com>
Within my form I have a field validated against a LOV. I have a POST_UPDATE trigger that I want to fire for this field. However if the user makes the field NULL by deleting the text that was there, the trigger never fires.
Date: Tue, 18 May 1999 19:50:04 GMT
Message-ID: <3741c3a3.12589723_at_news.int.westgroup.com>
Within my form I have a field validated against a LOV. I have a POST_UPDATE trigger that I want to fire for this field. However if the user makes the field NULL by deleting the text that was there, the trigger never fires.
Does anyone know how I can still use validation against an LOV but allow a NULL value to be acceptable also. I'm not sure why setting the field to NULL causes the trigger to not fire either.
Thanks
Paul Piotrowski
ppiotrowski_at_riag.com
Received on Tue May 18 1999 - 21:50:04 CEST