Devart Forums

Hi.

I'd like to suggest a couple of features to be implemented in debug window. The idea is to treat SQL queries with parameters a bit differently. As for now when we have a query like the one below

select * from dual where 1=:P

The parameter P is going to be displayed at the very bottom of debug window in a form of

:P(INTEGER)=123

I see two problems related to this approach, both are about executing the query being debugged.
1. It's not possible to simply select all the text in a window (Ctrl+A doesn't work) and then execute it as parameters section obviously cannot be recognized as a valid SQL expression.
I suggest commenting the whole section with /* */.

2. When a query becomes really complex and contains a lot of parameters it gets hard to substitute them with actual values.
It would be nice to have ODAC to make in-place value substitutions like this:
select * from dual where 1=123/*:P*/
Personally I think this feature would be useful for everyone.

Looking forward for reply, thanks in advance.

Hello,

We will review the possibility to implement your suggestion. Also if you have any other suggestions on expanding functionality or adding new features, you can post them on our UserVoice page at http://devart.uservoice.com/forums/1046 ... 915-oracle , and if enough people vote for it, it will be implemented (the more people vote for it, the sooner it will be implemented).