Red Gate forums :: View topic - SQL Prompt 5 **STILL** not getting *it* with 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 EAP
SQL Prompt 5 EAP forum

SQL Prompt 5 **STILL** not getting *it* with XML functions..

Search in SQL Prompt 5 EAP forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
mscheuner



Joined: 07 Dec 2005
Posts: 39
Location: Switzerland

PostPosted: Thu Oct 14, 2010 4:43 pm    Post subject: SQL Prompt 5 **STILL** not getting *it* with XML functions.. Reply with quote

Folks, this is disappointing - since about V2 or V3, I've been trying to explain that SQL Prompt *CANNOT* capitalize the XML XQuery function names as provided by SQL Server - and it still does....

Imagine a table with an XML column called "EntryData" - when I start typing:

SELECT EntryData.value(caret is here)
FROM dbo.MyTable

then I'm *CLEARLY* trying to use one of the five XML data type methods (.exist(), .modify(), .nodes(), .query(), .value()) - see here: http://msdn.microsoft.com/en-us/library/ms190798.aspx

Those XML data type methods are **CASE-SENSITIVE* - so SQL Prompt should *NEVER* uppercase those! Please!!

Unfortunately, if I press the space in my query being written in the above sample, I'm left with:

SELECT EntryData.VALUE
FROM dbo.MyTable

and now my XML function is no longer valid - I have to go back and manually turn it to lowercase again.

Is it really not possible to

- detect that the column I'm operating on is of type "XML"
- the string I just typed is one of the five mentioned above (that is a complete list)
- and in this case - just do *NOT* kick in the UPPERCASING (which I like otherwise - great feature - JUST NOT HERE!)
Back to top
View user's profile Send private message
TSchwab



Joined: 11 Jan 2008
Posts: 62
Location: Germany

PostPosted: Wed Oct 20, 2010 8:24 am    Post subject: Reply with quote

You are absolutely right.

I posted the problem in SQL-Prompt 4.0 and got the following answer:
Quote:

Anu Deshpande

PostPosted: Wed Feb 24, 2010 10:40 am
Apologies for the inconvenience caused by this issue.

It is logged in our internal tracking system (SP-2914).

We are working on this and I will update you as soon as it is fixed.

Many thanks for your patience.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com


Any chance to get this feature in SQL-Prompt 5.0?
_________________
Regards,

Thorsten
Back to top
View user's profile Send private message
TSchwab



Joined: 11 Jan 2008
Posts: 62
Location: Germany

PostPosted: Wed Oct 20, 2010 8:25 am    Post subject: Reply with quote

By the way, here is the link to my forum post: http://www.red-gate.com/MessageBoard/viewtopic.php?t=10403
Rolling Eyes
_________________
Regards,

Thorsten
Back to top
View user's profile Send private message
mscheuner



Joined: 07 Dec 2005
Posts: 39
Location: Switzerland

PostPosted: Thu Nov 11, 2010 5:50 pm    Post subject: Final SQL Prompt 5 preview - and issue is still *NOT FIXED* Reply with quote

I was a bit saddened to hear about the "final preview version" of SQL Prompt 5 being out, and this issue is **STILL** **NOT** **FIXED** .......
Back to top
View user's profile Send private message
AndyIrving



Joined: 06 Feb 2009
Posts: 13

PostPosted: Fri Nov 12, 2010 11:15 am    Post subject: Reply with quote

agree, this is very frustrating!
Back to top
View user's profile Send private message
Luke Jefferson



Joined: 17 Sep 2010
Posts: 33

PostPosted: Sun Nov 14, 2010 5:38 pm    Post subject: Reply with quote

You're right, it's a frustrating flaw, and I completely agree with your complaint. I've run into this myself a few times when writing queries.

If it were a straightforward fix, believe me, we would have tackled it already, but sadly it's part of the parser and whilst the team were keen to work on improving certain aspects of it, there was no scope to look at modifying that part of the code base in this release; the last rewrite of the parser took twelve months.

We do try our best to accommodate as many user requests as possible, but we can't solve all the problems due to resource limitations. I understand this is really frustrating for you and it's a valid complaint; it isn't that we think it's fine as it is or that it is not worth fixing, it's just that we have had higher priority issues to tackle. All that said, I will do my best to push for this fix in the future and would ask readers of this post to chip in to add weight to the case.

Luke Jefferson
Product Manager
Red Gate Software
Back to top
View user's profile Send private message
AndyIrving



Joined: 06 Feb 2009
Posts: 13

PostPosted: Mon Nov 15, 2010 1:12 pm    Post subject: Reply with quote

Sorry if this sounds a little harsh, but... new in this release is the removal of sql refactor and only some of those features put into sql prompt, plus script as alter?
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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