Page 1 of 1

Error on adding new record

Posted: Sun Sep 26, 2004 10:08 pm
by winsonlee
I have a field name customer id which is a primary key. So everytime when a user tried adding a customer id which existed in the table, it will comes out an error msg. I would like to know how am i able to handle such error msg ? Eg .. if customer id exist, then an error msg will be printed out. For your information i am using oracle as my database.

Posted: Sun Sep 26, 2004 10:16 pm
by feyd
hmm.. well.. you could check to see if the customer id exists already (with a select). if so, output your own error message.