Test Window Enhancements

[Gustavo]

Hi, Marco,

1. Could we have the track bar in the Test Window? This would make it easier to Test the current Select/Update/Delete.

2. Could you implement Test and Explain Plan for Update/Delete the same way it works for Select (test and explain actions available in track bar, for instance)?

3. When we Test a Select/Update/Delete from a running debug session, could you auto-assign the current values from the debug session to the bind variables?

4. There is a "Switch between editor/results" for the SQL Window. Could we have a "Switch between editor/variables" for the Test Window? Maybe you could use the same shortcut for both.

Regards,
Gustavo

 

[Marco Kalter]

1. Could we have the track bar in the Test Window? This would make it easier to Test the current Select/Update/Delete.

What exactly do you mean by "track bar"?

2. Could you implement Test and Explain Plan for Update/Delete the same way it works for Select (test and explain actions available in track bar, for instance)?

If you mark a delete or update statement and right-click on it, you can select "Test" or "Explain Plan" from the popup menu.

3. When we Test a Select/Update/Delete from a running debug session, could you auto-assign the current values from the debug session to the bind variables?

I have added this to the list of enhancement requests.

4. There is a "Switch between editor/results" for the SQL Window. Could we have a "Switch between editor/variables" for the Test Window? Maybe you could use the same shortcut for both.

This has been added for 9.0.

 

[Gustavo]

1. Could we have the track bar in the Test Window? This would make it easier to Test the current Select/Update/Delete.

What exactly do you mean by "track bar"?

I guess the correct name is "code hierarchy pane".

2. Could you implement Test and Explain Plan for Update/Delete the same way it works for Select (test and explain actions available in track bar, for instance)?

If you mark a delete or update statement and right-click on it, you can select "Test" or "Explain Plan" from the popup menu.

Yeah, I know. But from the code hierarchy pane it would be easier.

3. When we Test a Select/Update/Delete from a running debug session, could you auto-assign the current values from the debug session to the bind variables?

I have added this to the list of enhancement requests.

Thx!

4. There is a "Switch between editor/results" for the SQL Window. Could we have a "Switch between editor/variables" for the Test Window? Maybe you could use the same shortcut for both.

This has been added for 9.0.

Great!

 

[Gustavo]

Hi, Marco,

In my understanding, item 1 would be too complicated to be delivered in the next version, and item 4 is done.

Are items 2 and 3 doable? Also, if 2 is not doable, could I accomplish this by building a plugin?

Regards,
Gustavo

 

[Marco Kalter]

We can't add many new features for 9.0.0 anymore. But it will remain on the to-do list.

 

[Gustavo]

OK, thx! But I'd still like to know if I could accomplish these by building plugins.

Regards,
Gustavo

 

[Marco Kalter]

No, these enhancements cannot be implemented through a Plug-In.

 

[Gustavo]

Well, let's hope to see these in 9.1, then.

Regards,
Gustavo

 

[Gustavo]

Hi,

Just popping this up to keep it in mind for 9.1.

Regards,
Gustavo