Toad World® Forums

Make Code not working

Make code isn’t working properly in the latest beta. When I select my text and then Ctrl-M Ctrl-V, I get the exact text that is in the TOAD Options for Make code. Not quite what I was expecting. :slight_smile:

For example, if I select this:

SELECT *
FROM validation_def,
(SELECT COUNT(*)
FROM validation_view)

And then use the Make Code I get this:

%SqlVar% := '%SqlText% ’ || CHR(10);
%SqlVar% := v_sql || ’ %SqlTextNext% ’ || CHR(10);

In the GA I properly get the code I was expecting:

v_sql := 'SELECT * ’ || CHR(10);
v_sql := v_sql || ’ FROM validation_def, ’ || CHR(10);
v_sql := v_sql || ’ (SELECT COUNT(*) ’ || CHR(10);
v_sql := v_sql || ’ FROM validation_view) ’ || CHR(10);

Thanks for looking into this!

Thanks, Phyllis. This is fixed for next beta.

Michael

On 10/21/2013 08:06 AM, phyllis.helton_1150 wrote:

Make Code not working

Thread created by phyllis.helton_1150
Make code isn’t working properly in the latest beta. When I select my text and then Ctrl-M Ctrl-V, I get the exact text that is in the TOAD Options for Make code. Not quite what I was expecting. :slight_smile:

For example, if I select this:

SELECT *

FROM validation_def,

 (SELECT COUNT(*)

  FROM validation_view)

And then use the Make Code I get this:

%SqlVar% := '%SqlText% ’ || CHR(10);

%SqlVar% := v_sql || ’ %SqlTextNext% ’ || CHR(10);

In the GA I properly get the code I was expecting:

v_sql := 'SELECT * ’ || CHR(10);

v_sql := v_sql || ’ FROM validation_def, ’ || CHR(10);

v_sql := v_sql || ’ (SELECT COUNT(*) ’ || CHR(10);

v_sql := v_sql || ’ FROM validation_view) ’ || CHR(10);

Thanks for looking into this!

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.