Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get error details from Postgres ODBC driver
Message
From
21/09/2019 17:54:26
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Get error details from Postgres ODBC driver
Miscellaneous
Thread ID:
01671026
Message ID:
01671026
Views:
65
Newer PostgreSql psqlODBC driver ( for example, 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 ?

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