Is there a setting that causes TOAD to prompt for a variable when it isn't declared (for testing purposes)?

Toad Data Point
1

While I like TOAD DP better than dbForge Studio, one feature that they have which is a huge time saver, is the ability for it to prompt for variables if they haven’t been declared yet. For example, I may have a long script with some declared variables at the top, and I am testing a section of the script that needs that variable. If I run just that block of code, I get an error that the variable hasn’t been declared. In dbForge, you get a pop-up where you can input the value you want to inject into the variable. This eliminates the need to run everything from the variable down, or having to declare the variable again just for the testing purposes. It also allows you to quickly try different values in the variable rather than actually hard coding it each time. Thoughts?

2

Can you post sample script and screenshot of being prompted from DBForge? TDP prompts for binds per sql and is not set up yet for blocks of code. So I need an example of what you are looking for.

3

Lets pretend I have a huge script, variables are declared at the top and are used throughout. I’m now testing a new statement that relies on one of these variables, but don’t want to run the entire script and don’t want to re-declare the variable just for testing purposes.

TOAD

dbForge Studio

4

Use :number instead of @number and Toad will prompt you.

5

Awesome! Thanks for the info. If there isnt already, we need a “cool tips and tricks” thread or something.

6

Good idea, there are a lot cooler stuff than that in Toad. Here is a link to some helpful videos: http://dev.toadforsqlserver.com/TDPVideos/TDPVideo.html#tab1

For automation Debie Peabody has a great series (sorry, can’t find the link) but she is the Toad automation goddess.

7

Greg, thanks for working that out and thanks for the kudos[H]

On the subject of prompting for binds we have added three separate features for prompting for binds. You can read about them in the release notes.

http://dev.toadfordataanalyst.com/releasenotes/latest/ToadDataPoint_ReleaseNotes.htm

They three features area;

  1. Publishing views with binds to Toad Intelligence Central.

  2. Prompting for binds in Automation Scripts

  3. Publishing Automation scripts that prompt for binds.

Check it out!

8

I forgot that i did make two tutorials you might enjoy. See attached.
Toad Data Point Tips and Tricks Professional Features.pdf (2.63 MB)

9

Here is one more.
Toad Data Point Tutorial.pdf (6.91 MB)