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