BorlandTalk.com

Guest

I'm working with some open-source delphi code that provides access to
database via ODBC. My Delphi app is a CGI program running in console
mode. It's working well, but there's something I'd like to be able to
do that so far eludes me.

The open-source delphi code is well-written, with exception-trapping,
etc. If we try to execute an SQL statement that contains some sort of
error, the exception raised displays the SQL error in the output
stream, and it appears in the web browser that's accessing my
program. However, the raised exception also stops execution of
my .exe, so the program is not able to gracefully handle SQL statement
errors.

I've altered the open source code to be able to turn off exceptions,
but so far have been unable to determine how to find the SQL error
message text that the exception was displaying.

I'll post some code if that would help better explain the problem -
please let me know....
..
Mark

Guest

Please disregard, solved it myself.....the error object contains a
Message field, the SQL error was found in it.....