Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <pgsql-odbc-owner+archive@lists.postgresql.org>)
	id 1vPfeS-00AiHQ-1V
	for pgsql-odbc@arkaria.postgresql.org;
	Sun, 30 Nov 2025 11:31:36 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-odbc-owner+archive@lists.postgresql.org>)
	id 1vPfeP-00GSaB-2W
	for pgsql-odbc@arkaria.postgresql.org;
	Sun, 30 Nov 2025 11:31:34 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <SRS0=A+/9=6G=postgres.rocks=davecramer@fastcrypt.com>)
	id 1vPfeP-00GSa2-1k
	for pgsql-odbc@lists.postgresql.org;
	Sun, 30 Nov 2025 11:31:33 +0000
Received: from pgintl.fastcrypt.com ([149.56.129.164])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <SRS0=A+/9=6G=postgres.rocks=davecramer@fastcrypt.com>)
	id 1vPfeI-002PKD-15
	for pgsql-odbc@postgresql.org;
	Sun, 30 Nov 2025 11:31:27 +0000
Received: from mail-io1-f52.google.com (mail-io1-f52.google.com
 [209.85.166.52])
	by pgintl.fastcrypt.com (Postfix) with ESMTPSA id 5748520229
	for <pgsql-odbc@postgresql.org>; Sun, 30 Nov 2025 06:31:25 -0500 (EST)
Received: by mail-io1-f52.google.com with SMTP id
 ca18e2360f4ac-9491604d00fso114732139f.2
        for <pgsql-odbc@postgresql.org>; Sun, 30 Nov 2025 03:31:25 -0800 (PST)
X-Gm-Message-State: AOJu0YzSbK+QlcMnbJbZDnoi4I4PbIWRP3qejdFMELVzFJiCMWOxc4ym
	oGrRDRdppYvkT9lioV1g+SxVdXgbzxNKh6a42YZYg0IAkCwuraZkBnCVGp343aiSdXB2c6KSRZZ
	TPGdx8j8fSPC+ulNwastrGkkMKEVF54c=
X-Google-Smtp-Source: 
 AGHT+IHbYvKKHG/Rvg3Pnhmt4+y4g8Xcg6pgcg3M6ADJC6RoVwXj+7lq0dV9oyR3trINEy4r4lJyERRr1DPsQqb0Ui4=
X-Received: by 2002:a05:6638:2a0a:b0:5b7:d710:661e with SMTP id
 8926c6da1cb9f-5b967ace4b3mr20278870173.21.1764502282423; Sun, 30 Nov 2025
 03:31:22 -0800 (PST)
MIME-Version: 1.0
References: 
 <CA+FnnTxse=q=47B7hbBKnJXeCy_GpyAyZ7hrAOD54nDSzYqhQA@mail.gmail.com>
In-Reply-To: 
 <CA+FnnTxse=q=47B7hbBKnJXeCy_GpyAyZ7hrAOD54nDSzYqhQA@mail.gmail.com>
From: Dave Cramer <davecramer@postgres.rocks>
Date: Sun, 30 Nov 2025 06:31:13 -0500
X-Gmail-Original-Message-ID: 
 <CADK3HH+MkPAaTkZ+Ay82Ch7bdN86RB2swUoD7p2-_2q_UGk=wA@mail.gmail.com>
X-Gm-Features: AWmQ_bk-LXdynau35zqyRXxQbBu2cECLAJ6MGWq0VB2mDSmR1ZnaxjR5avXYtNk
Message-ID: 
 <CADK3HH+MkPAaTkZ+Ay82Ch7bdN86RB2swUoD7p2-_2q_UGk=wA@mail.gmail.com>
Subject: Re: Catch "RAISE NOTICE" in ODBC application
To: Igor Korot <ikorot01@gmail.com>
Cc: PostgreSQL ODBC list <pgsql-odbc@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000bfd7ad0644ce3368"
List-Id: <pgsql-odbc.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-odbc@lists.postgresql.org>
List-Owner: <mailto:pgsql-odbc-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-odbc>
Archived-At: 
 <https://www.postgresql.org/message-id/CADK3HH%2BMkPAaTkZ%2BAy82Ch7bdN86RB2swUoD7p2-_2q_UGk%3DwA%40mail.gmail.com>
Precedence: bulk

--000000000000bfd7ad0644ce3368
Content-Type: text/plain; charset="UTF-8"

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.
>
>
>

--000000000000bfd7ad0644ce3368
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>ChatGPT shows this:</div><div><br></div><div>SQLGetDi=
agRec(<br>=C2=A0 =C2=A0 SQL_HANDLE_STMT, =C2=A0// statement handle<br>=C2=
=A0 =C2=A0 hstmt,<br>=C2=A0 =C2=A0 iRecord, =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0// record number, starting at 1<br>=C2=A0 =C2=A0 SqlState,<br>=C2=A0 =C2=
=A0 &amp;NativeError,<br>=C2=A0 =C2=A0 MessageText,<br>=C2=A0 =C2=A0 Buffer=
Length,<br>=C2=A0 =C2=A0 &amp;TextLengthPtr<br>);<br></div><div><br></div><=
div><p>Notices will have:</p>
<ul>
<li>
<p><code>SqlState =3D &quot;00000&quot;</code></p>
</li>
<li>
<p><code>NativeError =3D 0</code></p>
</li>
<li>
<p><code>MessageText =3D &quot;&lt;your NOTICE text&gt;&quot;</code></p>
</li>
</ul>
<p></p></div><div><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=
=3D"gmail_signature"><div dir=3D"ltr">Dave Cramer<div>www.postgres.rocks</d=
iv></div></div></div><br></div><br><div class=3D"gmail_quote gmail_quote_co=
ntainer"><div dir=3D"ltr" class=3D"gmail_attr">On Sun, 30 Nov 2025 at 02:58=
, Igor Korot &lt;<a href=3D"mailto:ikorot01@gmail.com">ikorot01@gmail.com</=
a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi=
, ALL,<br>
How do I do that?<br>
<br>
Google showed only the libpq way...<br>
<br>
Thank you.<br>
<br>
<br>
</blockquote></div>

--000000000000bfd7ad0644ce3368--