Toad World® Forums

New Editor - Code Template Quote Problem

I just tried to use my existing code templates with the new editor for the first time and found that instead of getting single quotes, I am getting ‘#39’, which obviously isn’t correct. I am also getting line breaks in the middle of the code incorrectly. In looking at the options, the incorrect characters are there as well.

In looking at other templates, it appears that any that use quotes are in there incorrectly. The assertloc template, which I am pretty sure is one packaged with TOAD is an example of the quote problem.

My template now looks like this (note the is broken up as is the getCreateIndexParams line – also note that on lines 1, 5, 6, and 7, the second ‘#3 is missing the 9’ ):

ddl.createIndex(in_owner => ‘#39’siebel’#3

, in_index_name => getNextIndexName(’#39’<pas’

te>’#39’, ‘#39’siebel’#39’, ‘#39’C’#39’)

, in_table_name => ‘#39’’#3

, in_unique => ‘#39’N’#3

, in_columns => '#39#3

, in_params => miscExpImpProcs.getCre’

ateIndexParams( ‘#39’siebel.’#39’, TRUE)

, in_make_bitmap => ‘#39’N’#39’);

when it should look like this:

ddl.createIndex(in_owner => ‘siebel’

, in_index_name => getNextIndexName(’’, ‘siebel’, ‘C’)

, in_table_name => ‘’

, in_unique => ‘N’

, in_columns => ‘’

, in_params => miscExpImpProcs.getCreateIndexParams( ‘siebel.’, TRUE)

, in_make_bitmap => ‘N’);


Phyllis Helton

Data Magician
Digital Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org

Phyllis,

The conversion routine is failing. I’ll take a look at it after the holidays.

Thanks,

Michael

On Dec 22, 2014, at 11:48 AM, phyllis.helton_1150 bounce-phyllishelton_1150@toadworld.com wrote:

New Editor - Code Template Quote Problem

Thread created by phyllis.helton_1150
I just tried to use my existing code templates with the new editor for the first time and found that instead of getting single quotes, I am getting ‘#39’, which obviously isn’t correct. I am also getting line breaks in the middle of the code
incorrectly. In looking at the options, the incorrect characters are there as well.

In looking at other templates, it appears that any that use quotes are in there incorrectly. The assertloc template, which I am pretty sure is one packaged with TOAD is an example of the quote problem.

My template now looks like this (note the is broken up as is the getCreateIndexParams line – also note that on lines 1, 5, 6, and 7, the second ‘#3 is missing the 9’ ):

ddl.createIndex(in_owner => ‘#39’siebel’#3

, in_index_name => getNextIndexName(’#39’<pas’

te>’#39’, ‘#39’siebel’#39’, ‘#39’C’#39’)

, in_table_name => ‘#39’’#3

, in_unique => ‘#39’N’#3

, in_columns => '#39#3

, in_params => miscExpImpProcs.getCre’

ateIndexParams( ‘#39’siebel.’#39’, TRUE)

, in_make_bitmap => ‘#39’N’#39’);

when it should look like this:

ddl.createIndex(in_owner => ‘siebel’

, in_index_name => getNextIndexName(’’, ‘siebel’, ‘C’)

, in_table_name => ‘’

, in_unique => ‘N’

, in_columns => ‘’

, in_params => miscExpImpProcs.getCreateIndexParams( ‘siebel.’, TRUE)

, in_make_bitmap => ‘N’);


Phyllis Helton

Data Magician

Digital Strategies, Cru | Data Sciences
& Analytics

Office :phone: 407-515-4452
phyllis.helton@cru.org

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.

Thanks Michael!

On Mon, Dec 22, 2014 at 12:14 PM, Michael Staszewski bounce-mstaszew@toadworld.com wrote:

Re: New Editor - Code Template Quote Problem

Reply by Michael Staszewski
Phyllis,

The conversion routine is failing. I’ll take a look at it after the holidays.

Thanks,

Michael

On Dec 22, 2014, at 11:48 AM, phyllis.helton_1150 bounce-phyllishelton_1150@toadworld.com wrote:

New Editor - Code Template Quote Problem

Thread created by phyllis.helton_1150
I just tried to use my existing code templates with the new editor for the first time and found that instead of getting single quotes, I am getting ‘#39’, which obviously isn’t correct. I am also getting line breaks in the middle of the code incorrectly. In looking at the options, the incorrect characters are there as well.

In looking at other templates, it appears that any that use quotes are in there incorrectly. The assertloc template, which I am pretty sure is one packaged with TOAD is an example of the quote problem.

My template now looks like this (note the is broken up as is the getCreateIndexParams line – also note that on lines 1, 5, 6, and 7, the second ‘#3 is missing the 9’ ):

ddl.createIndex(in_owner => ‘#39’siebel’#3

, in_index_name => getNextIndexName(’#39’<pas’

te>’#39’, ‘#39’siebel’#39’, ‘#39’C’#39’)

, in_table_name => ‘#39’’#3

, in_unique => ‘#39’N’#3

, in_columns => '#39#3

, in_params => miscExpImpProcs.getCre’

ateIndexParams( ‘#39’siebel.’#39’, TRUE)

, in_make_bitmap => ‘#39’N’#39’);

when it should look like this:

ddl.createIndex(in_owner => ‘siebel’

, in_index_name => getNextIndexName(’’, ‘siebel’, ‘C’)

, in_table_name => ‘’

, in_unique => ‘N’

, in_columns => ‘’

, in_params => miscExpImpProcs.getCreateIndexParams( ‘siebel.’, TRUE)

, in_make_bitmap => ‘N’);


Phyllis Helton
Data Magician
Digital Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452
phyllis.helton@cru.org

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.

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.


Phyllis Helton

Data Magician
Digital Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org

Phyllis, this is fixed for the next beta; however, it won’t fix those corrupted templates in your beta. Since this issue won’t affect upgrading users of the GA
I didn’t want to waste time correcting a beta-only issue.

In next beta, to get your prior Toad’s templates into the beta do the following…

Close beta

Delete EditorCodeTemplates.xml from beta’s appdata User Files folder

Copy LexLib.lxl from prior Toad’s appdata User Files folder to beta’s appdata User Files folder

Toad should now convert your old templates properly. Let me know if you see any issues

Thanks,

Michael

From: phyllis.helton_1150 [mailto:bounce-phyllishelton_1150@toadworld.com]

Sent: Monday, December 22, 2014 11:49 AM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] New Editor - Code Template Quote Problem

New Editor - Code Template Quote Problem

Thread created by phyllis.helton_1150

I just tried to use my existing code templates with the new editor for the first time and found that instead of getting single quotes, I am getting ‘#39’, which obviously isn’t
correct. I am also getting line breaks in the middle of the code incorrectly. In looking at the options, the incorrect characters are there as well.

In looking at other templates, it appears that any that use quotes are in there incorrectly. The assertloc template, which I am pretty sure is one packaged with TOAD is an example
of the quote problem.

My template now looks like this (note the is broken up as is the getCreateIndexParams line – also note that on lines 1, 5, 6, and 7, the second ‘#3 is missing the 9’
):

  ddl.createIndex(in_owner        => '#39'siebel'#3



                ,  in_index_name   => getNextIndexName('#39'<pas' 

te>’#39’, ‘#39’siebel’#39’, ‘#39’C’#39’)

                ,  in_table_name   => '#39'<paste>'#3

                ,  in_unique       => '#39'N'#3

                ,  in_columns      => '#39#3



                ,  in_params       => miscExpImpProcs.getCre' 

ateIndexParams( ‘#39’siebel.’#39’, TRUE)

                ,  in_make_bitmap  => '#39'N'#39');

when it should look like this:

  ddl.createIndex(in_owner        => 'siebel'

                ,  in_index_name   => getNextIndexName('<paste>', 'siebel', 'C')

                ,  in_table_name   => '<paste>'

                ,  in_unique       => 'N'

                ,  in_columns      => ''

                ,  in_params       => miscExpImpProcs.getCreateIndexParams( 'siebel.<paste>', TRUE)

                ,  in_make_bitmap  => 'N');

Phyllis Helton

Data Magician

Digital Strategies, Cru | Data Sciences & Analytics

Office :phone: 407-515-4452

phyllis.helton@cru.org

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.

Great! I’ll give it a try.

On Wed, Jan 14, 2015 at 12:49 PM, Michael Staszewski bounce-mstaszew@toadworld.com wrote:

RE: New Editor - Code Template Quote Problem

Reply by Michael Staszewski
Phyllis, this is fixed for the next beta; however, it won’t fix those corrupted templates in your beta. Since this issue won’t affect upgrading users of the GA I didn’t want to waste time correcting a beta-only issue.

In next beta, to get your prior Toad’s templates into the beta do the following…

  1.   Close beta
    
  1.   Delete EditorCodeTemplates.xml from beta's appdata User Files folder
    
  1.   Copy LexLib.lxl from prior Toad's appdata User Files folder to beta's appdata User Files folder
    

Toad should now convert your old templates properly. Let me know if you see any issues

Thanks,

Michael

From: phyllis.helton_1150 [mailto:bounce-phyllishelton_1150@toadworld.com]
Sent: Monday, December 22, 2014 11:49 AM
To: toadoraclebeta@toadworld.com
Subject: [Toad for Oracle - Beta Discussion Forum] New Editor - Code Template Quote Problem

New Editor - Code Template Quote Problem

Thread created by phyllis.helton_1150

I just tried to use my existing code templates with the new editor for the first time and found that instead of getting single quotes, I am getting ‘#39’, which obviously isn’t correct. I am also getting line breaks in the middle of the code incorrectly. In looking at the options, the incorrect characters are there as well.

In looking at other templates, it appears that any that use quotes are in there incorrectly. The assertloc template, which I am pretty sure is one packaged with TOAD is an example of the quote problem.

My template now looks like this (note the is broken up as is the getCreateIndexParams line – also note that on lines 1, 5, 6, and 7, the second ‘#3 is missing the 9’ ):

  ddl.createIndex(in_owner        => '#39'siebel'#3
                ,  in_index_name   => getNextIndexName('#39'<pas' 

te>’#39’, ‘#39’siebel’#39’, ‘#39’C’#39’)

                ,  in_table_name   => '#39'<paste>'#3
                ,  in_unique       => '#39'N'#3
                ,  in_columns      => '#39#3
                ,  in_params       => miscExpImpProcs.getCre' 

ateIndexParams( ‘#39’siebel.’#39’, TRUE)

                ,  in_make_bitmap  => '#39'N'#39');

when it should look like this:

  ddl.createIndex(in_owner        => 'siebel'
                ,  in_index_name   => getNextIndexName('<paste>', 'siebel', 'C')
                ,  in_table_name   => '<paste>'
                ,  in_unique       => 'N'
                ,  in_columns      => ''
                ,  in_params       => miscExpImpProcs.getCreateIndexParams( 'siebel.<paste>', TRUE)
                ,  in_make_bitmap  => 'N');

Phyllis Helton
Data Magician
Digital Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org

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.

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.


Phyllis Helton

Data Magician
Digital Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org