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
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". 
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
xsuffix
OK, this should be fixed next beta.
Thanks John, I see what the problem is now. 
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.