| In a Multi-record block ,How can I restrict [message #80731] |
Mon, 11 November 2002 00:10  |
RohitM
Messages: 1
Registered: November 2002
|
Junior Member |
|
|
Hi All,
In a Multi-record block ,How can I restrict user to enter duplicate values in a particular column.
I hv to made a check a for this BEFORE COMMIT.
Pls remember this check is reqd . before saving the data to the database.
Regards
Rohit
|
|
|
|
| Re: In a Multi-record block ,How can I restrict [message #80735 is a reply to message #80731] |
Mon, 11 November 2002 03:16  |
Yendra
Messages: 1
Registered: November 2002
|
Junior Member |
|
|
Declare
xx varchar2(30);
Begin
xx := :block.field
Go_Block('xxx') --> block name
First_Record;
Loop
If :block.field_name = xx Then
raise form_trigger_failure;
End If;
If :system.last_record = 'TRUE' then
exit;
End If;
Next_Record;
End Loop;
End;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
