Sunday, February 19, 2012

Inserting of Duplicate Records Error Message

I would like to know what options I have with regards to trapping a duplicate record
before it tries to post to a SQL database. I have set the column to unique in SQL. But
when I try to use ASP and post a duplicate record I get a system error. I would like to
just create a referential error to notify the user that they cannot post a duplicate record
please try again. Any help would be greatly appreciated.

RTRefer toTry... Catch... Block in the code

Does this helps?

No comments:

Post a Comment