I have a query with parameters inside a Devart TMSQuery.SQL. Something like
select * from customers
where customer = :CustomerID
in code I do
// Delphi
sqlcustomer.ParamByName('CustomerID').asinteger := 4;
sqlcustomer.open;
I want to debug and see the exact sql command sent to the server, if I try to use TMSQuery.sql I just have the :CustomerID, while I would like to have this:
select * from customers
where customer = 4
is there a quick way to have this without reading all the parameters and reconstructing manyally the query?
Of course I have a very big query with more than 100 parameters, this is why I need this