meta data for this page
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:v8_0_0:howto:getsql [2020/07/15 14:47] sylvainair [Procedure] |
en:v8_0_0:howto:getsql [2020/07/28 15:14] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Retrieving SQL code from a query ====== | ====== Retrieving SQL code from a query ====== | ||
| - | It can happen, for example for a debug, that you want to know which SQL code is actually executed on the database server. Here is how to proceed. | + | It can happen, for example for a debug, that you want to know which SQL code is actually executed on the database server. |
| + | If statistics are activated, you only have to search for the line related to desired execution in VIGILENS_EXEC of statistics database. SQL code is stored in QUERYSQL column. | ||
| + | |||
| + | If statistics are not activated, here is how to proceed. | ||
| <WRAP round alert> | <WRAP round alert> | ||
| - | WARNING: the following manipulation requires : | + | **WARNING**: the following manipulation requires : |
| * administrator privileges on the machine | * administrator privileges on the machine | ||
| Line 15: | Line 18: | ||
| * In windows, search for regedit, right-clic > Run as administrator\\ | * In windows, search for regedit, right-clic > Run as administrator\\ | ||
| {{:en:v8_0_0:howto:pasted:20200715-143635.png?nolink}} | {{:en:v8_0_0:howto:pasted:20200715-143635.png?nolink}} | ||
| - | + | * Navigate in the tree structure to the node ''Computer > HKEY_LOCAL_MACHINE > SOFTWARE > Wow6432Node > EVIDENS > Param'' (''Computer > HKEY_LOCAL_MACHINE > SOFTWARE > EVIDENS > Param'' 32 bits machines) | |
| - | * Navigate in the tree structure to the node ''Computer > HKEY_LOCAL_MACHINE > SOFTWARE > Wow6432Node > EVIDENS > Param'' | + | |
| * in the right pannel, right-clic > new > Valeur DWORD 32 bits\\ | * in the right pannel, right-clic > new > Valeur DWORD 32 bits\\ | ||
| - | {{:en:v8_0_0:howto:pasted:20200715-144148.png}} | + | {{:en:v8_0_0:howto:pasted:20200715-144148.png?nolink}} |
| * edit the value of the key, in hexadecimal form : | * edit the value of the key, in hexadecimal form : | ||
| * 1 ⇒ the log will be created | * 1 ⇒ the log will be created | ||
| - | * 0 ⇒ the log will not be created\\ {{:en:v8_0_0:howto:pasted:20200715-144638.png}} | + | * 0 ⇒ the log will not be created\\ {{:en:v8_0_0:howto:pasted:20200715-144638.png?nolink}} |
| - | * The log file will be created in the same folder than [[v8_0_0:designer:start|designer]] ".exe". | + | * The log file will be created in the same folder than [[:en:v8_0_0:designer:start|designer]] ".exe". |
| <WRAP round info> | <WRAP round info> | ||