From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | pgsql-odbc <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Error handling in ODBC |
Date: | 2001-06-18 06:06:05 |
Message-ID: | 3B2D9A4D.13B1053A@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Dave Page wrote:
>
> > -----Original Message-----
> > From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
> > Sent: 14 June 2001 11:09
> > To: Dave Page
> > Cc: Zoltan Kovacs; pgsql-odbc
> > Subject: Re: [ODBC] Error handling in ODBC
> >
> >
> > Dave Page wrote:
> > >
> >
> > [snip]
> >
> > >
> > > As far as I can tell, it is then not possible to access the notice
> > > from a client app (cetainly SQLError won't return it in my
> > test prog,
> > > yet I can quite happily get a real error from an invalid query for
> > > example.
> > >
> >
> > Hmm it may be possible that SQLERROR returns a notice message
> > in an appropriate condition(?????) though I'm not sure.
>
> Unfortunately I'm not really familiar enough with either C or the guts of
> the driver to know or be able to figure out in a reasonable amount of time
> (though I have spent hours staring at the code :-)) what exactly it is/is
> trying to do. I do know it's not doing what I need it to :-(, and - I
> suspect - what it should be doing (though these are not necessarily one and
> the same).
>
IMHO *ERROR* messages should return SQL_ERROR with the SQLSTATE <>
"00000". As for NOTICEs we seem to be able to change the driver to
return SQL_SUCCESS_WITH_INFO and let the succeeding SQLError() to
return the NOTICE message.
However I've not recognized the circumstances why both ERRORs and
(some) NOTICEs return SQL_ERROR with the SQLSTATE = '00000' now.
Comments ?
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Dariusz Pietrzak | 2001-06-18 08:05:19 | Feature request -> autoreconnect. |
Previous Message | Hiroshi Inoue | 2001-06-18 02:14:04 | Re: Re: MSACCESS & Apostrophe in Column Name |