Re: Forms 3.0 trigger Q

ericc_at_ucsee.EECS.Berkeley.EDU (Eric Chu) writes:

>I have a question about writing key triggers in Forms 3.0 ..
>Is there any way I can write the trigger to execute some of my own code
>and then continue on with its default operation? It seems that for many
>Key triggers, once it is superceded by a user-defined trigger, there is
>no real way of duplicating the original function.
 

>Specifically, I'd like to write a trigger for Key-DELREC which would
>make some checks before deleting a record.
 

>Thanks.
 

>Eric Chu
>ericc_at_ucsee.eecs.berkeley.edu

If I understand your question correctly - this should do the trick:

Create a KEY-DELREC trigger, containing:

	BEGIN
		--your own code to check/validate/whatever,
		--optionally with exception handler in order to
		--avoid delete record if your check fails 

		delete_record;
	END

We do it all the time, works fine here.

Regards,

| Carsten Kristensen		| E-mail: ckr_at_ocsbrg.no 	|
| Offshore Computer Services AS | Tel   : +47 55 99 88 70	|
| Bergen, Norway		| Fax   : +47 55 99 88 84	|
 =================================================================