How to get error details from Visual Foxpro using latest driver

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: How to get error details from Visual Foxpro using latest driver
Date: 2019-03-04 07:51:46
Message-ID: DF76A6A059BB4D5989CB6BED807F5F2C@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Latest PostgreSql official psqlODBC driver (version 11.00.0000 , 32 bit)
does not return error details in Microsoft Visual Foxpro.

After error FoxPro commands

AERROR(laerror)
disp memory like laerror

returns same error message in laerror third element:

LAERROR Local A showerror
( 1, 1) N 1526 ( 1526,00000000)
( 1, 2) C "Connectivity error: ERROR: insert or update o
n table "rid" violates foreign key constraint
"rid_yhik_fkey";
Error while executing the que
ry"
( 1, 3) C "ERROR: insert or update on table "rid" violat
es foreign key constraint "rid_yhik_fkey";
Err
or while executing the query"
( 1, 4) C "23503"
( 1, 5) N 1 ( 1,00000000)
( 1, 6) N 1 ( 1,00000000)
( 1, 7) C

in older psqlODBC driver

laError[1,3] contains error details:

Key (yhik)=(TK ) is not present in table "mootyhik".;

How to get error details using latest psqlODBC driver ?
I can provide odbc log or use additional ODBC API calls if those can invoked
from FoxPro

Posted also in

https://stackoverflow.com/questions/54978713/how-to-get-psqlodbc-error-details-in-visual-foxpro

Andrus.

Browse pgsql-odbc by date

  From Date Subject
Next Message Igor Korot 2019-03-24 03:42:01 Re: Building libpq independently of server
Previous Message Shore, Ronald 2019-03-01 15:51:22 Issue with some Postgresql ODBC drivers in SAS