OraFAQ Forum: Forms » Restriction on new record addtion in datablock through form menu plus icon

Home » Developer & Programmer » Forms » Restriction on new record addtion in datablock through form menu plus icon (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restriction on new record addtion in datablock through form menu plus icon [message #524327]

Fri, 23 September 2011 00:34

sudhir2btcscom
Messages: 2
Registered: September 2011
Location: WEST BENGAL

Junior Member

Hi,
i am populating 3 records in my data block.i do not want more than 3 rows.butwhen i click the plus icon in form menu one more row is getting generated which i do not want.please help me so that i can restrict the new record addtion through plus icon in menu bar for a particular block.its urgent.

Thanks In Advance....

Report message to a moderator

Re: Restriction on new record addtion in datablock through form menu plus icon [message #524331 is a reply to message #524327]

Fri, 23 September 2011 00:57

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Create a block-level WHEN-CREATE-RECORD trigger:

if :system.trigger_record > 3 then
   message('3 records allowed');
   raise form_trigger_failure;
end if;

Report message to a moderator

Previous Topic:	Master Detail Form (Wrong Data)
Next Topic:	Performance issue with WHERE clause

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 07 12:59:21 CDT 2024