Actual SQL statement?

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dwilbourn
Posts: 6
Joined: Thu 01 Feb 2018 16:21

Actual SQL statement?

Post by dwilbourn » Wed 14 Mar 2018 10:21

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?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Actual SQL statement?

Post by ViktorV » Wed 14 Mar 2018 13:47

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

Post Reply