How to get an SQL statement with expanded macros / where / orderby and params ?

[swierzbicki]

Hello,

How to get an SQL statement with expanded macros / where / orderby and params ?
FinalSQL doesn't expand Parameters.

Thank you

[AlexP]

Hello,

If you want to retrieve the query text with parameter values being already pasted, you need to parse the query text in the OnSQL event and paste parameter values instead of their names, that can be retrieved with a loop through all parameters.

[swierzbicki]

Hello Alex,

Is there any reasons why FinalSQL doesn't expands parameters ?

BR

[AlexP]

This is because of the fact that in majority of servers parameters are not set in the query, but binded.