Toad World® Forums

Issues with Code Snippets

I’m finding the snippet creation behavior strange/inconsistent in the
current release.

Here’s an example. I wanted to create a new snippet called
“con” for “Constraint” containing this structure:

CONSTRAINT DF_TableName_FieldName DEFAULT (EnterDefaultHere)

If you type the statement in the snippet window like this:

CONSTRAINT DF_TableName_FieldName DEFAULT (EnterDefaultHere)

Highlight the “EnterDefaultHere” text that you want to make into a
parameter, and then click the “+” button on the Parameters tab to
add a new parameter, you get this:

CONSTRAINT DF_TableName_FieldName DEFAULT (EnterDefaultHere)

automatically. (i.e. it creates the parameter, and adds the $ prefix and suffix
to what you had highlighted)

ISSUE #1 – Parameter not automatically prefixed/suffixed (apparently when
text selected is touching another character that isn’t a bracket).

Now, highlight the “TableName” text, and click the Add button:
“+”

CONSTRAINT DF_TableName_FieldName DEFAULT (EnterDefaultHere)

This time you get this result:

CONSTRAINT DF_TableName_FieldName DEFAULT (EnterDefaultHere)

Expected Result:

Attachment not added (too many attachments): "image015.png"
Attachment not added (too many attachments): "image016.png"
Attachment not added (too many attachments): "image017.png"
Attachment not added (too many attachments): "image018.png"
Attachment not added (too many attachments): "image012.png"
Attachment not added (too many attachments): "image019.png"
Attachment not added (too many attachments): "image020.png"

image001.png

image004.png

image005.png

image006.png

image007.png

image005.png

image006.png

image010.png

image011.png

image013.png

image014.png
image001.png

Hello, Darren!

Thanks for your so detailed report.
We will definitely create CRs to improve it.

Issue #1. The issue is related with the “_” character, because it works normally if define the parameter for the text from “DF.TableName.FieldName” structure.

Best wishes, Julia.