How to trap ODBC errors. I am using "On error goto last".
But the error reported by ODBC gives like "S1000" which is an alphanumeric whereas On error is a numeric field. Hence unable to compare . In other words whenever I get ODBC error , it simply (error) flashing on the .
HOW DO I TRAP IT???