![SoftTree Technologies](templates/GreenTech/images/logo.gif) |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2110
|
|
[SA 9.0.176 Pro] - Delimiters vs Prefixes |
|
Ignore Name Prefixes doesn't work properly when Always Add Delimiters is set to Always add brackets [ ]. I suppose it's because after adding delimiters '[' is considered part of the name. Selecting from the popup the view named v_nyomvonal_tetelek_insert in schema xform became
![](templates/GreenTech/images/code_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
[xform].[v_nyomvonal_tetelek_insert] AS vnti
|
even though Ignore Name Prefixes had 'v_' to ignore. After adding '[v_' to the list, the code turned into
![](templates/GreenTech/images/code_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
[xform].[v_nyomvonal_tetelek_insert] AS nti
|
as expected.
I haven't checked but I guess it affects other types of delimiters as well.
|
|
Sun Oct 30, 2016 8:54 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7855
|
|
|
|
Unfortunately it seems to affect all delimiters. I can reproduce this issue too. It looks like the Always Add Delimiters options cannot be used along Ignore Name Prefixes.
I'm going to raise this issue and ask if that can be fixed.
|
|
Tue Nov 01, 2016 8:17 am |
|
![](templates/GreenTech/images/spacer.gif) |
gemisigo
Joined: 11 Mar 2010 Posts: 2110
|
|
|
|
Thank you very much. Meanwhile, I'm going to add delimited versions of prefixes. That should work until there's a fix.
|
|
Tue Nov 01, 2016 3:56 pm |
|
![](templates/GreenTech/images/spacer.gif) |
gemisigo
Joined: 11 Mar 2010 Posts: 2110
|
|
|
|
One more issue with adding delimiters: setting that option to Always add brackets [ ] will add those delimiters to variable names too when selecting a stored procedure from popup for EXECUTE, ending with something like:
![](templates/GreenTech/images/code_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
EXECUTE [logs].[usp_bekeres_logolas]
[@ip_v4] = NULL
,[@ip_v6] = NULL
,[@debug] = NULL
|
Parsing such statements will fail because of the syntax error. Selecting variables from popup is unaffected.
|
|
Mon Nov 07, 2016 11:20 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7855
|
|
|
|
Thank you very much. I'm logging this issue too. Hope it can be fixed quickly.
|
|
Mon Nov 07, 2016 11:38 am |
|
![](templates/GreenTech/images/spacer.gif) |
gemisigo
Joined: 11 Mar 2010 Posts: 2110
|
|
|
|
Adding delimiters to parameter variable names for a stored procedure is no longer an issue. Ignoring name prefixes with added delimiters still is.
Could you post a short list of intended bugfixes so that we don't spam the forum re-reporting issues that are known as not fixed yet?
|
|
Mon Nov 21, 2016 5:51 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7855
|
|
|
|
![](templates/GreenTech/images/quote_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
Could you post a short list of intended bugfixes so that we don't spam the forum re-reporting issues that are known as not fixed yet? |
Certainly. We will post them ASAP.
![](templates/GreenTech/images/quote_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
Ignoring name prefixes with added delimiters still is |
Prefixes with delimiters aren't currently supported it seems. No changes in the release notes for this and previous internal builds refer to that one.
|
|
Mon Nov 21, 2016 3:08 pm |
|
![](templates/GreenTech/images/spacer.gif) |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|