Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to get error details from psqlODBC driver
Message
From
04/03/2019 03:12:53
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
How to get error details from psqlODBC driver
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Application:
Desktop
Miscellaneous
Thread ID:
01666946
Message ID:
01666946
Views:
55
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  
Also SYS(2018) contains same message.

in older psqlODBC driver version

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
Next
Reply
Map
View

Click here to load this message in the networking platform