|
-
Jun 30th, 2005, 07:08 AM
#1
Thread Starter
Member
Ignoring ADO errors
What can I do to avoid the program stopping with an ADO error? It does not seem to be "trappeable"
Example:
objComm.CommandText = "INSERT INTO CorpExtractType (CorpCode, ExtractTypeID) VALUES ('" & sCorpCode & "'," & CStr(iExtractTypeID) & ")"
objComm.Execute()
This may fail due to a duplicate key for example, but I don't want to check for each command to see if the record already exist as it would slow things down. I just want to ignore any errors, but it won't play
Putting a try-catch arround it does not help as it bombs on the objcomm.Execute statement.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|