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;
Comments
Got something to say?