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

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson, Paul Stephenson

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

Postby mscheuner » Thu Oct 14, 2010 4:43 pm

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!)
mscheuner
 
Posts: 39
Joined: Wed Dec 07, 2005 7:17 am
Location: Switzerland

Postby TSchwab » Wed Oct 20, 2010 8:24 am

You are absolutely right.

I posted the problem in SQL-Prompt 4.0 and got the following answer:
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
TSchwab
 
Posts: 62
Joined: Fri Jan 11, 2008 9:47 am
Location: Germany

Postby TSchwab » Wed Oct 20, 2010 8:25 am

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

Thorsten
TSchwab
 
Posts: 62
Joined: Fri Jan 11, 2008 9:47 am
Location: Germany

Final SQL Prompt 5 preview - and issue is still *NOT FIXED*

Postby mscheuner » Thu Nov 11, 2010 5:50 pm

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** .......
mscheuner
 
Posts: 39
Joined: Wed Dec 07, 2005 7:17 am
Location: Switzerland

Postby AndyIrving » Fri Nov 12, 2010 11:15 am

agree, this is very frustrating!
AndyIrving
 
Posts: 13
Joined: Fri Feb 06, 2009 10:10 am

Postby Luke Jefferson » Sun Nov 14, 2010 5:38 pm

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
Luke Jefferson
 
Posts: 33
Joined: Fri Sep 17, 2010 10:26 am

Postby AndyIrving » Mon Nov 15, 2010 1:12 pm

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?
AndyIrving
 
Posts: 13
Joined: Fri Feb 06, 2009 10:10 am


Return to SQL Prompt 5 EAP

Who is online

Users browsing this forum: No registered users and 2 guests