| Author |
Message |
mscheuner
Joined: 07 Dec 2005
Posts: 39
Location: Switzerland
|
 Posted: Tue Aug 18, 2009 12:44 pm Post subject: SQL Prompt 4 - *STILL* doesn't "get it" when it comes to XML |
 |
|
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 |
|
 |
Anu Deshpande
Joined: 20 Apr 2009
Posts: 591
Location: Cambridge
|
| Posted: Wed Sep 02, 2009 1:25 pm Post subject: |
|
|
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 |
|
|
|
|
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
