Home » Developer & Programmer » Forms » Check in multi block records (forms6i)
Check in multi block records [message #327195] Sat, 14 June 2008 11:30 Go to next message
srinivas.k2005
Messages: 334
Registered: August 2006
Senior Member
Hi,

I have a multi block record, and when the user enters a value more than 6 times i have to stop him ,showing that it has exeeded 6.
Block two items A and B:
A B
1 q
2 q
3 q
4 q
5 q
6 q
7 q

in the above case i have to stop him showing q exceeded more than 6 times even before saving the chnages to database.
So which is the best method to handle this:
putting in a PL/SQL table and stoping him
OR
putting the values in temporary table and stopping him
or is there anyother way to stop him efficient and fast ,
.If PL/SQL table is good ,can you please show an example how to perform with a PL/SQL table.

Above B is a varchar2 field.

Thanks,
Srinivas

[Updated on: Sat, 14 June 2008 11:30]

Report message to a moderator

Re: Check in multi block records [message #328086 is a reply to message #327195] Wed, 18 June 2008 22:32 Go to previous message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

show your sample form then we can solve it.

kanish
Previous Topic: STACKED CANVAS ISSUE
Next Topic: How to Change the TEXT in the Form
Goto Forum:
  


Current Time: Mon Dec 05 10:48:15 CST 2016

Total time taken to generate the page: 0.24257 seconds