Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

want to implement primary key on forms field

yash_08031983Jun 6 2013 — edited Jun 6 2013
Hello, experts,

i have a form with single base table deptno.
dept_name and deptno . deptno is primary key in database table.
when i enter records, it prevent to insert duplicate value in deptno text box when i insert or update .

form this i create a block with base table dept. block's property Enforce Primary key is yes.
then i set deptno fields primary key property to yes.
when i enter duplicate records then save , it prevent to insert but i want the following:

i run the form, when i enter first record, if it exist in table then prevent to insert. also after inserting first record,
if i again insert same deptno in next record it should also prevent.

please help me out.

thanks
Yash
This post has been answered by CraigB on Jun 6 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 4 2013
Added on Jun 6 2013
4 comments
1,377 views