You can put a Unique index on most databases with Null values because (in Oracle anyway Null does not equal Null. I just add one last week with Null Values.
>>> Rick Cook <[EMAIL PROTECTED]> Mar 31, 2007 8:41 AM >>> Your form has a unique index that is being violated. I assume you know what that means. Figure out which field(s) is/are indexed with the unique flag set, and ensure that you're not trying to add a value that already exists for that field. Keep in mind that a NULL value is also considered a value - duplicate NULLs will return that error, too. Rick -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Siti Hawa Bee SHAIK FARID Sent: Saturday, March 31, 2007 6:42 AM To: arslist@ARSLIST.ORG Subject: SOS- URGENT HELP entry violate a unique index My Dear Listers, I really need your expert advise to resolve this issue. When I created a case and saved it, I was hit with this error msg " ARERR[382] The value for this entry violate a unique index that has been defined for this form. I had done the SQL, filter, DB and active link logging but I dun see that error msg in the logs and I still do not know where the error msg comes from and what is it checking on that refrain me from submitted a case. I had initially deleted the cases from HPD:Helpdesk and when re-importing hit the error msg. Now when I tried to create just a simple new case and submit, I also hit the same error message. Because I need to reimport again, I had deleted helpdesk records from table T369, B369 and H369. I would appreciate if anyone of you out there can come to my rescue. Please render your help. UOB EMAIL DISCLAIMER Any person receiving this email and any attachment(s) contained, shall treat the information as confidential and not misuse, copy, disclose, distribute or retain the information in any way that amounts to a breach of confidentiality. If you are not the intended recipient, please delete all copies of this email from your computer system. As the integrity of this message cannot be guaranteed, neither UOB nor any entity in the UOB Group shall be responsible for the contents. Any opinion in this email may not necessarily represent the opinion of UOB or any entity in the UOB Group. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
