How to get the real postgreql error from visual basic

From: "dfx" <dfx(at)dfx(dot)it>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to get the real postgreql error from visual basic
Date: 2008-07-27 17:36:57
Message-ID: 2EB96675DFFD4D2E9CD8F82CC414C73C@athlon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear Sirs,

when I execute a function that returns an error, visual basic shows always
the same error code ( -214767259) but I would like to know the real postgres
code of the error.

The visual basic code that I use is the following:

Dim Cmd As new ADODB.Command
Cmd.CommandText = "delete from <tablename> where id=<some_number>;"
Cmd.ActiveConnection = mvarConnection
Cmd.Execute

Whichever error appens the visual basic Err object returns the same number.

What I have to do?

Any suggestion will be appreciated.

Domenico

Responses

Browse pgsql-general by date

  From Date Subject
Next Message aravind chandu 2008-07-27 19:29:26 Getting data from Xml to Postgresql database
Previous Message 赵 熠 2008-07-27 13:57:19 why my postgresql auto crashed???