OraFAQ Forum: Forms » Tabular form

Home » Developer & Programmer » Forms » Tabular form (oracle 10g)

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

Tabular form [message #572865]

Tue, 18 December 2012 05:24

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

hello and hi everybody...

i have master and detail form.
In detail(tabular form) i want
to restrict user to enter only
10 rows.if he tries to go for 11th row
he shud get a message (Only 10 records can be created at a time)

kindgly please help me out.

Thanks in advnace.

Report message to a moderator

Re: Tabular form [message #572866 is a reply to message #572865]

Tue, 18 December 2012 05:38

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

Senior Member
Account Moderator

In WHEN-CREATE-RECORD trigger, use something like this:

if :system.trigger_record > 10 then
   message('Only 10 records can be ...');
   raise form_trigger_failure;
end if;

Report message to a moderator

Re: Tabular form [message #572882 is a reply to message #572866]

Tue, 18 December 2012 06:33

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

Thank u very much...

I will not lie to you...you are awesome...!!

thanks again.

Report message to a moderator

Re: Tabular form [message #573246 is a reply to message #572882]

Tue, 25 December 2012 01:38

dude4084
Messages: 222
Registered: March 2005
Location: Mux

Senior Member

I will not lie to you...you are awesome...!!

I second that !

Report message to a moderator

Previous Topic:	How to Add Text items at run time?
Next Topic:	Query in Tab Canvas

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 20:15:37 CDT 2024