SQL Prompt capitalizes XML functions

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

SQL Prompt capitalizes XML functions

Postby eugef » Wed Jun 12, 2013 9:54 pm

Hello, I recently started to use "SQL Prompt 5" for my SQL development and came across this issue.

We have a lot of xml manipulation done in the stored procedures in our system and when I type one of SQL xml functions "SQL Propmpt" capitalize them which makes function invalid, because they are case-sensitive.

DECLARE @EntityXml XML = '<Root><Child/></Root>'

@EntityXml.QUERY('/Root/Child') is invalid.

Unfortunately there is no way to undo formatting. Every time i hit space of period the function gets capitalized and even when I hit "Esc" after that formatting are not reverted and function stays CAPITALIZED, creating "catch 22" situation. I need to go back and retype the function and as soon as I hit any other key it gets capitalized.
The only way out I found is to type my functions intentionally type wrong function name (usually with extra character at the end like "valuee" and then get back and fix it.

I went through options and could find a way to disable this capitalization.

Can someone advise on any solution. It's very annoying and frustrating.

Thank you
eugef
 
Posts: 15
Joined: Wed May 29, 2013 10:17 pm

Postby eddie davis » Fri Jun 14, 2013 9:36 am

Hi
Thank you for your forum post.

By default SQL Prompt will UPPERCASE, 'reserved keywords', 'Built-in functions' and 'built-in data types'

Try editing the SQL Prompt options ->Format ->Case and modify the 'select the case to use for:' for each option 'reserved keywords', 'Built-in functions' and 'built-in data types' using the dropdown to 'Leave as is'.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby eugef » Fri Jun 14, 2013 2:32 pm

Hi Eddie,

I had "Build-in functions" set to "Leave as is", but that didn't resolve the issue.

Now I also set "Build-in data types" to "Leave as is" (which doesn't make sence, since xml functions are not data types) but even that didn't resolved the issue.
eugef
 
Posts: 15
Joined: Wed May 29, 2013 10:17 pm

Postby eddie davis » Fri Jun 21, 2013 3:33 pm

Thank you for your reply.

I can confirm that this is abug in SQL Prompt and updated an existing Bug Report whose reference is SP-2914.

I have reassigned the Bug Report to the current Product Manager and requested that he review the Bug Report.

I understand that this is a frustrating problem for you and sadly there is not a work around for it. I will update this post when I receive further information.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby eugef » Fri Jun 21, 2013 3:43 pm

Thank you. Please, keep me posted.
eugef
 
Posts: 15
Joined: Wed May 29, 2013 10:17 pm

Postby JonathanWatts » Mon Jul 01, 2013 4:02 pm

Hi there,

We have just released an early access release of Prompt where we don’t uppercase xml functions while you type any more.

You can download it here: http://www.red-gate.com/products/sql-de ... ompt-6-eap

Hope that helps,

Jonathan Watts
- Red Gate
JonathanWatts
 
Posts: 401
Joined: Wed Dec 15, 2004 11:05 am
Location: Red Gate Software

Postby eugef » Mon Jul 01, 2013 4:04 pm

That is great. Thank you so much. :D :D
eugef
 
Posts: 15
Joined: Wed May 29, 2013 10:17 pm

Postby eugef » Mon Jul 01, 2013 4:11 pm

Just a quick question, is this free upgrade with my current SQL Prompt 5 licence ?
eugef
 
Posts: 15
Joined: Wed May 29, 2013 10:17 pm

Postby JonathanWatts » Mon Jul 01, 2013 4:30 pm

Currently the EAP is free to use, however it will expire at the end of July. When we do the final release this it will be a new major version - SQL Prompt v6. As such it will be a free upgrade if you have a support and upgrades contract, otherwise it will be a paid upgrade.

Regards,

Jonathan Watts
- Red Gate
Jonathan Watts

-Project Manager
-Red Gate Software Ltd
JonathanWatts
 
Posts: 401
Joined: Wed Dec 15, 2004 11:05 am
Location: Red Gate Software


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 1 guest