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.