Which triggers to use?
Date: Mon, 29 Jun 1998 20:27:59 GMT
Message-ID: <6n8tcf$v9c$1_at_nnrp1.dejanews.com>
[Quoted] [Quoted] I am still in the process of getting used to Oracle's (Forms 4.5) triggers.
[Quoted] I have a date field called date_received. I have an alert that is set up with style Stop, one button (OK).
When the person enters a new record, I would like to have the user notifed of any errors right there and then (without even moving off the record). If I use a When-New-Item instance as a trigger on this item, the only time this fires is as I either move onto (as in an edit mode) or when I move back onto after entering it (as in Add mode).
When the person goes to save the record, I'd like for this trigger to fire, and then put the person in the field that needs to be corrected. So, I set up a When_Validate_record trigger that should fire whenever I begin to save the record. My alert will fire, but it doesn't acutally stop the action and insist on a corect date (it just goes ahead and saves the record as is after the message.)
Any help will be appreciated!
-Chris R
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Jun 29 1998 - 22:27:59 CEST