Red Gate forums :: View topic - SQL Prompt capitalizes XML functions
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

SQL Prompt capitalizes XML functions

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
eugef



Joined: 29 May 2013
Posts: 15

PostPosted: Wed Jun 12, 2013 9:54 pm    Post subject: SQL Prompt capitalizes XML functions Reply with quote

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
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 924
Location: Red Gate Software

PostPosted: Fri Jun 14, 2013 9:36 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
eugef



Joined: 29 May 2013
Posts: 15

PostPosted: Fri Jun 14, 2013 2:32 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 924
Location: Red Gate Software

PostPosted: Fri Jun 21, 2013 3:33 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
eugef



Joined: 29 May 2013
Posts: 15

PostPosted: Fri Jun 21, 2013 3:43 pm    Post subject: Reply with quote

Thank you. Please, keep me posted.
Back to top
View user's profile Send private message
JonathanWatts



Joined: 15 Dec 2004
Posts: 400
Location: Red Gate Software

PostPosted: Mon Jul 01, 2013 4:02 pm    Post subject: Reply with quote

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-development/sql-prompt/entrypage/sql-prompt-6-eap

Hope that helps,

Jonathan Watts
- Red Gate
Back to top
View user's profile Send private message
eugef



Joined: 29 May 2013
Posts: 15

PostPosted: Mon Jul 01, 2013 4:04 pm    Post subject: Reply with quote

That is great. Thank you so much. Very Happy Very Happy
Back to top
View user's profile Send private message
eugef



Joined: 29 May 2013
Posts: 15

PostPosted: Mon Jul 01, 2013 4:11 pm    Post subject: Reply with quote

Just a quick question, is this free upgrade with my current SQL Prompt 5 licence ?
Back to top
View user's profile Send private message
JonathanWatts



Joined: 15 Dec 2004
Posts: 400
Location: Red Gate Software

PostPosted: Mon Jul 01, 2013 4:30 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
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


Powered by phpBB © 2001, 2005 phpBB Group