Request a Demo
Home   >   mailing lists

Re: Catch "RAISE NOTICE" in ODBC application - Mailing list pgsql-odbc

From Dave Cramer
Subject Re: Catch "RAISE NOTICE" in ODBC application
Date
Msg-id CADK3HH+MkPAaTkZ+Ay82Ch7bdN86RB2swUoD7p2-_2q_UGk=wA@mail.gmail.com
Whole thread Raw
In response to Catch "RAISE NOTICE" in ODBC application  (Igor Korot <ikorot01@gmail.com>)
List pgsql-odbc
Tree view
ChatGPT shows this:

SQLGetDiagRec(
    SQL_HANDLE_STMT,  // statement handle
    hstmt,
    iRecord,          // record number, starting at 1
    SqlState,
    &NativeError,
    MessageText,
    BufferLength,
    &TextLengthPtr
);

Notices will have:

  • SqlState = "00000"

  • NativeError = 0

  • MessageText = "<your NOTICE text>"

Dave Cramer
www.postgres.rocks


On Sun, 30 Nov 2025 at 02:58, Igor Korot <ikorot01@gmail.com> wrote:
Hi, ALL,
How do I do that?

Google showed only the libpq way...

Thank you.


pgsql-odbc by date:

Previous
From: Igor Korot
Date:
Subject: Catch "RAISE NOTICE" in ODBC application
Next
From: Igor Korot
Date:
Subject: Re: Catch "RAISE NOTICE" in ODBC application