|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
how do i do error handling using asp...
liek taking an example i am getting this error on trying to save a record twice whihc has a primary key constraint: 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. how can i handle such cases and where do i place the code??? thanks! |
|
#2
|
|||
|
|||
|
Well...it's up to *YOU* the programmer to make sure these errors don't happen...
Perhaps you might want to *CHECK* if the record already exist *BEFORE* you actually try and INSERT it(if that is what your doing) Otherwise if you mean: I want to *trap* the error and move on then try the: On Error Resume Next approach Hope this helps! Sincerely Vlince |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > error handling |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|