CODEWITHSUNDEEP
oracle-databaseoracle11goracleforms
Abdullah Bahattab
Abdullah Bahattab

Reputation: 716

how to determine the number of rows allowed to enter from form using oracle forms 6i?

using database: oracle database 11.2

using form builder: oracle forms builder 6i

I have a screen which builded in oracle forms 6i, where the end user can enter data. This screen deals with only one table in the database. I want to set a certain number of lines in the table if it reaches that number the end user cannot enter other data.

Upvotes: 0

Views: 462

Answers (1)

Littlefoot
Littlefoot

Reputation: 142733

What a strange requirement ...

Anyway, you could create a WHEN-NEW-RECORD-INSTANCE block-level trigger and put this in there:

if :system.trigger_record = 10 then             --> 10 represents limit
   message('You can not enter any more rows');
   raise form_trigger_failure;
end if;

Upvotes: 0

Related Questions