OraFAQ Forum: Forms » How to check uniqness of a field in forms 6i

Home » Developer & Programmer » Forms » How to check uniqness of a field in forms 6i

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

How to check uniqness of a field in forms 6i [message #192734]

Wed, 13 September 2006 07:13

vaishnavm
Messages: 5
Registered: September 2006
Location: Baroda

Junior Member

Hi!,
We have a web-based ERP system with Oracle 9i & forms 6i. I am developing a form in which I want to check the uniqness of a field say EMPID on block level(multiple record block).

I have already written a code which checks the uniqness by nevigating the block in a loop but I wanted to know if any easy method (inbuilt??) available for this.

Thanks
Mayank

Report message to a moderator

Re: How to check uniqness of a field in forms 6i [message #192833 is a reply to message #192734]

Wed, 13 September 2006 16:45

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Don't cross-post (and yes, I agree, this question belongs to Forms forum; it is my problem that I read the OraFAQ forum bottom-up).

[EDIT] Corrected the wrong URL.

[Updated on: Wed, 13 September 2006 16:46]

Report message to a moderator

Re: How to check uniqness of a field in forms 6i [message #193088 is a reply to message #192734]

Thu, 14 September 2006 20:38

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Look at http://www.orafaq.com/forum/m/182177/67467/?srch=record+group#msg_182177

David

Report message to a moderator

Re: How to check uniqness of a field in forms 6i [message #193410 is a reply to message #192734]

Sat, 16 September 2006 06:33

Liza79
Messages: 74
Registered: September 2006

Member

well i think you are trying to ask how to check duplication in the values entered in the multiple record in one go....if so then set the primary key propertry of the field to yes. and the problem solved. no need to write the code.

Report message to a moderator

Previous Topic:	generate different exp name
Next Topic:	Regarding POST and Database trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:46:01 CDT 2024