>I have a form that inserts in SQL 6.5. Whenever I violate my primary key with the form . I get a sloppy SQL error returned on a page in my browser. Does anyone know how I can trap this and if the error occurs redirect the URL?
Use On Error Resume Next and check for the error number right after you do the insert. If the error occurred, do a response.redirect.
Tim Westmoreland
Software Engineer
Skyline Technologies, Inc.
"Upper classes are a nation's past; the middle class is its future." - Ayn Rand, Russian-born author (1905-1982).