Restrict User From Entering More Than 100 Records

August 14, 2007 · Print This Article

You can write following code at WHEN-CREATE-RECORD trigger of that block to restrict user entering upto 100 records.

IF to_number(:system.cursor_record) > 99 THEN
raise form_trigger_failure;
END IF;

Related Posts

Comments

Got something to say?