Re: Retrieve SQL error position from Delphi 3

From: Helmut Hahn <Helmut.Hahn_at_bitoek.uni-bayreuth.de>
Date: Wed, 20 May 1998 10:53:34 +0200
Message-ID: <35629A0E.CA836B81@bitoek.uni-bayreuth.de>

Holger Heidenbluth wrote:

> Hi all,
>
> Using Pro*C it is possibile to retrieve the position of parsing errors
>
> by reading the sqlca structure. Is it possible to get this information
>
> from Delphi using the BDE?

You could put the Execute or Open of your TQuery in a try{}catch(...){} block.
If an error occours you have the an object of type TDatabaseerror available in the catch block.
You could examine the TDatabaseerror.Message and you should find the original Oracle message there.

Helmut

>
>
> Regards
>
> Holger Heidenbluth
>
> --
> KeepTool Software GbR Home : http://www.keeptool.com
> Schützalle 118 EMail: holger.heidenbluth_at_keeptool.com
> D-14169 Berlin Phone: +49-172-5272025
Received on Wed May 20 1998 - 03:53:34 CDT