Toad World® Forums

Editor - substitution variable followed by period (.) not working with F9

SELECT ‘&&sub.suffix’ FROM dual;

Data grid displays &&sub.suffix

F5 is working correctly :

Time Start: 4/10/2017 5:01:22 PM
old: SELECT ‘&&sub.suffix’ FROM dual
new: SELECT ‘testsuffix’ FROM dual

‘TESTSUFFIX’

testsuffix
1 row selected.
Elapsed: 00:00:01.03
Time End: 4/10/2017 5:01:25 PM
Elapsed Time for Script Execution: 2 secs

Morning,

If you need to follow a substitution variable, by a dot, use two dots. This is the same as you need to do in SQL*Plus.

Cheers,

Norm. [TeamT ]

On 10 April 2017 23:02:51 BST, droeschley_109 bounce-droeschley_109@toadworld.com wrote:

Editor - substitution variable followed by period (.) not working with F9

Thread created by droeschley_109
SELECT ‘&&sub.suffix’ FROM dual;

Data grid displays &&sub.suffix

F5 is working correctly :

Time Start: 4/10/2017 5:01:22 PM
old: SELECT ‘&&sub.suffix’ FROM dual
new: SELECT ‘testsuffix’ FROM dual

‘TESTSUFFIX’

testsuffix
1 row selected.
Elapsed: 00:00:01.03
Time End: 4/10/2017 5:01:25 PM
Elapsed Time for Script Execution: 2 secs

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

Sent from my Android device with K-9 Mail. Please excuse my brevity.

The problem is the Editor is not doing the substitution when I execute a statement (F9) with a substitution variable followed by a period. It prompts for the value for the substitution variable but doesn’t do the substitution.

SELECT ‘&&sub.suffix’ FROM dual; should display “testsuffix” when I enter “test” as the value - it displays “&&sub.suffix”

Surely if you have an ampersand, or two, it prompts for a value with F5 or F9? Is this happening? If it is, and no substitution takes place then perhaps it’s a “feature”. :wink:

If I remember tomorrow, I’ll try it at work.

Cheers,

Norm. [TeamT]

On 11 April 2017 15:20:20 BST, droeschley_109 bounce-droeschley_109@toadworld.com wrote:

RE: Editor - substitution variable followed by period (.) not working with F9

Reply by droeschley_109
The problem is the Editor is not doing the substitution when I execute a statement (F9) with a substitution variable followed by a period. It prompts for the value for the substitution variable but doesn’t do the substitution.

SELECT ‘&&sub.suffix’ FROM dual; should display “testsuffix” when I enter “test” as the value - it displays “&&sub.suffix”

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

Sent from my Android device with K-9 Mail. Please excuse my brevity.

Norm, Toad is prompting but not substituting.

SQL*Plus does this:

SQL> SELECT ‘&&sub.suffix’ FROM dual;
Enter value for sub: x
old 1: SELECT ‘&&sub.suffix’ FROM dual
new 1: SELECT ‘xsuffix’ FROM dual

'XSUFFI

xsuffix

OK, this should be fixed next beta.

Thanks John, I see what the problem is now. :wink:

It must be a beta feature as it works fine in 12.1.0.22.

Cheers,

Norm.

John, I just noticed in .65 that Toad is treating &&sub. (substitution variable) as a separate variable from &&sub (substitution variable without the dot).

SELECT ‘prefix&&sub.suffix &&sub’ FROM dual;

This statement displays 2 substitution variables in the Variable popup window, but there should only be 1.

Yeah , I see what you mean. Fixed for next beta.