469,910 Members | 1,492 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,910 developers. It's quick & easy.

error handling in asp-userfrindly messages

hi ...

I want to do error handling in my application. I have made a complete
application. but when I encounter errors (like mentioned below) I want to do
error handling. how can I do it?

I mean like in this case I can see if the record is being added duplicate
then I can always check for duplicate records and throw a message. but I
will face so many errors like this??? do we have a list ..whereby I can get
all the error numbers and there meanings and I generate my own user-friendly
errors?

I hope I am clear..thanks for any suggestion
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the
table were not successful because they would create duplicate values in the
index, primary key, or relationship. Change the data in the field or fields
that contain duplicate data, remove the index, or redefine the index to
permit duplicate entries and try again.
Jul 19 '05 #1
1 2677
monika wrote:
hi ...

I want to do error handling in my application. I have made a complete
application. but when I encounter errors (like mentioned below) I
want to do error handling. how can I do it?

I mean like in this case I can see if the record is being added
duplicate then I can always check for duplicate records and throw a
message. but I will face so many errors like this??? do we have a
list ..whereby I can get all the error numbers and there meanings and
I generate my own user-friendly errors?

I hope I am clear..thanks for any suggestion
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] The changes you requested
to the table were not successful because they would create duplicate
values in the index, primary key, or relationship. Change the data in
the field or fields that contain duplicate data, remove the index, or
redefine the index to permit duplicate entries and try again.


Use

On Error Resume Next

to disable the builtin error-handling. On the line following the one where
you attempt the insert or update, test the Err object to see if an error
occurred.

If Err.Number <> 0 then
'an error occurred
end if

Remember to turn the builtin error handler back on with

On Error GoTo 0

Do you have the vbscript documentation? If not: http://tinyurl.com/7rk6

HTH,
Bob Barrows

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jon LaRosa | last post: by
8 posts views Thread by Erencans | last post: by
6 posts views Thread by Josť Joye | last post: by
3 posts views Thread by Mr Newbie | last post: by
1 post views Thread by GS | last post: by
4 posts views Thread by DavideR | last post: by
9 posts views Thread by Trapulo | last post: by
1 post views Thread by sean_walsh | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.