Showing the Values of Bind Variables in the Debug Log

A new option has been added to the Query Properties screen when editing an ADO connection to allow you to enable logging of bind variable values for this connection.

Query Properties screen in the ADO connection showing new option - Include bind variable values in the debug log

If this box is checked, queries that appear in the debugging log will also include a line showing the value of each bind variable used in the query. This can assist in troubleshooting queries that are not performing as expected.

<Info ...>select field1 from table where field2 = ?</Info> <Debug ...>Bind variable 1 = SomeValue</Debug>

An extra line will print in the log file for each bind variable in the query. You should leave this option unchecked when not debugging, to prevent the log file from becoming overly large.