Postgres Pro
Downloads
Home   >   mailing lists

Thread: I wonder why I don't get an exception on delphi?

I wonder why I don't get an exception on delphi?

From
"Ligia M. Pimentel"
Date:
I'm using Delphi (windows) to develop a  database application using Postgres
7.1 in linux.
When I use delphi with other databases and I try to insert a record that
violates referential integrity I get an exception, but with postgres I
don't, I tried to insert the same record on PSQL and I get an error, could
it be the ODBC driver?

Please help me, if you know...


Thank you.

Ligia

RE: I wonder why I don't get an exception on delphi?

From
"Trewern, Ben"
Date:

Have you tried the following components:

http://www.zeos.dn.ua/download/zeosdbo-5.2.3-beta.zip

They seem to work more reliably and much more quickly than the ODBC drivers.  They also give the required errors ;-)

Regards

Ben

P.S. Very New Home Page http://www.zeoslib.org

> -----Original Message-----
> From: Ligia M. Pimentel [mailto:lmpc@nettaxi.com]
> Sent: 14 March 2001 23:30
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] I wonder why I don't get an exception on delphi?
>
>
> I'm using Delphi (windows) to develop a  database application
> using Postgres
> 7.1 in linux.
> When I use delphi with other databases and I try to insert a
> record that
> violates referential integrity I get an exception, but with postgres I
> don't, I tried to insert the same record on PSQL and I get an
> error, could
> it be the ODBC driver?
>
> Please help me, if you know...
>
>
> Thank you.
>
> Ligia
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

RE: I wonder why I don't get an exception on delphi?

From
"Hiroshi Inoue"
Date:
> -----Original Message-----
> From: Ligia M.Pimentel
>
> I'm using Delphi (windows) to develop a  database application
> using Postgres
> 7.1 in linux.
> When I use delphi with other databases and I try to insert a record that
> violates referential integrity I get an exception, but with postgres I
> don't, I tried to insert the same record on PSQL and I get an error, could
> it be the ODBC driver?
>
> Please help me, if you know...
>

Try the latest ODBC driver at http://www.greatbridge.org/project/pgadmin/.
It includes an change about error reporting.

regards,
Hiroshi Inoue