OraFAQ Forum: Forms » Check in multi block records

Home » Developer & Programmer » Forms » Check in multi block records (forms6i)

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

Check in multi block records [message #327195]

Sat, 14 June 2008 11:30

srinivas.k2005
Messages: 404
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