Home » Developer & Programmer » Forms » How to check uniqness of a field in forms 6i
How to check uniqness of a field in forms 6i [message #192734] Wed, 13 September 2006 07:13 Go to next message
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
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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Look at http://www.orafaq.com/forum/m/182177/67467/?srch=record+group#msg_182177

David
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 Go to previous message
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.
Previous Topic: generate different exp name
Next Topic: Regarding POST and Database trigger
Goto Forum:
  


Current Time: Sat Dec 10 01:10:07 CST 2016

Total time taken to generate the page: 0.25895 seconds