Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can i see actual query sent through SQLEXEC
Message
De
07/03/2017 03:35:13
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows 7
Database:
MS SQL Server
Divers
Thread ID:
01648813
Message ID:
01648816
Vues:
49
J'aime (1)
Another approach might be to globally replace your SqlExec calls to WrapSqlExec(nHandle, cSQL, nLog, nTime,uOther)
and build your own function with sensible defaults for logging, timing and so on which can be overridden at each call through optional parameters. In the long run it will give you more flexibility and information for a tiny effort.

>Hi
>Assuming i have the following:
>myVar = "test"
>mySql = "select * from myTable where someField=?myVar"
>=sqlExec( Handle, mySql )
>
>
>How can i see the actual query sent to the backend DB? I need this to build an auditlog. Afterwards, i will cursortoxml() the resulting sqlresult cursor for the saved response, but i need the actual values sent...
>
>Many thanks
>Jaime
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform