DBMonitor show real query

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
gemal
Posts: 3
Joined: Thu 04 Feb 2010 11:50

DBMonitor show real query

Post by gemal » Mon 02 Aug 2010 11:35

Is there a setting in DBMonitor so that I can see the "real" query instead of he query with ":ID" in it?

Currently I have to click on "paramters" to figure out the real query

I see:
SELECT * FROM test WHERE id = :ID

I want to see:
SELECT * FROM test WHERE id = 50

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 02 Aug 2010 14:05

dbMonitor works with many SQL servers and products and therefore we can't support such functionality. For most servers and for MySQL prepared queries, queries are passed without real parameters, but parameters are passed in a specific format.

Post Reply