Red Gate forums :: View topic - SQL Prompt 4 - *STILL* doesn't "get it" when it comes to XML
Return to www.red-gate.com RSS Feed Available

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

SQL Prompt 4 - *STILL* doesn't "get it" when it comes to XML

Search in SQL Prompt Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
mscheuner



Joined: 07 Dec 2005
Posts: 39
Location: Switzerland

PostPosted: Tue Aug 18, 2009 12:44 pm    Post subject: SQL Prompt 4 - *STILL* doesn't "get it" when it comes to XML Reply with quote

I'm a bit annoyed - SQL Prompt 4 STILL doesn't "get it" when it comes to SQL XML DML support......

Imagine a table something like this:

Code:

CREATE TABLE MyDemoTable
   (ID INT IDENTITY(1,1) PRIMARY KEY,
    Title VARCHAR(50),
    Payload XML)


If I want to change some content in the "Payload" XML column, I can do this with an UPDATE statement:

Code:

UPDATE MyDemoTable
SET Payload.modify('replace value of ..... with "...." ')


The problem is: those keywords ".value", ".modify" that I type AFTER the XML column name (Payload) ARE CASE SENSITIVE - but SQL Prompt insists on UPPERCASING those.

Yes, I know, I can turn off uppercasing all together - but that's at best a hackish workaround......

Is it really not possible for SQL Prompt to detect, that when I type:

Code:

UPDATE MyDemoTable
SET Payload.


that "Payload" is an XML column, and therefore, if I now proceed to type "modify" and a space or opening parenthesis, that it should never force this "modify" to UPPERCASE ?

What happens now is:

Code:

UPDATE MyDemoTable
SET Payload.modify


and as soon as I type "(" now, I get:

Code:

UPDATE MyDemoTable
SET Payload.MODIFY(


and that's just not valid SQL XML DML syntax anymore.

See this link here for the SQL XML DML keywords:

http://msdn.microsoft.com/en-us/library/ms190798.aspx

All five of those (.query(), .nodes(), .value(), .modify(), .exist() ) are case-sensitive and should definitely be left alone when used on a XML column!


Marc
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Wed Sep 02, 2009 1:25 pm    Post subject: Reply with quote

Apologies for the delay in replying your post and thank you for your request.

We have logged this in our enhancement request database as SP-2794.
If we get sufficient interest in this feature we’ll considering putting it in a future release.

Kindly let us know if you have any other issues/questions regarding SQL prompt, I'll like to help.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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