Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to get error details from psqlODBC driver
Message
De
04/03/2019 03:12:53
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
How to get error details from psqlODBC driver
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Application:
Desktop
Divers
Thread ID:
01666946
Message ID:
01666946
Vues:
56
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform