I have been trying to debug an SQL statement but can't find a way to get the actual SQL statement with the parameters expanded. I can't find anything about parameters in the MySQL documentation so I presume they must get expanded before they are sent to the server? Both the finalSQL property and the DBMonitor app show the SQL text with the parameters still in place.
According to the documentation, finalSQL expands any macros so why not any parameters?
Actual SQL statement?
Re: Actual SQL statement?
The FinalSQL property contains the text of the query that is sent to the server. A sample of using parameters can be found in MyDAC help: https://devart.com/mydac/docs/devart.da ... params.htm