Home » Developer & Programmer » Forms » Tabular form (oracle 10g)
Tabular form [message #572865] Tue, 18 December 2012 05:24 Go to next message
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.
Re: Tabular form [message #572866 is a reply to message #572865] Tue, 18 December 2012 05:38 Go to previous messageGo to next message
Littlefoot
Messages: 19890
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;

Re: Tabular form [message #572882 is a reply to message #572866] Tue, 18 December 2012 06:33 Go to previous messageGo to next message
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.
Re: Tabular form [message #573246 is a reply to message #572882] Tue, 25 December 2012 01:38 Go to previous message
dude4084
Messages: 217
Registered: March 2005
Location: Mux
Senior Member
I will not lie to you...you are awesome...!!


I second that !
Previous Topic: How to Add Text items at run time?
Next Topic: Query in Tab Canvas
Goto Forum:
  


Current Time: Sat Dec 20 17:21:59 CST 2014

Total time taken to generate the page: 0.24368 seconds