Re: Error Handling

If you are doing an insert just have a package handle the insert. If the values should be unique or is a foreign key they will fail if wrong. The error code should then be caught by ASP and a relevant message produced for the user.

You don't need error handling in the package (unless you want a record of it, but if you do just remember to use RAISE afterwards so that the front end will still get the error.).

hth
R.

--
Posted via http://dbforums.com