Comments
Sort by recent activity
Hi Pete,
It got better, now it takes about 10 refreshes to get the Exception. This is much better. / comments
Hi Pete,
It got better, now it takes about 10 refreshes to get the Exception. This is much better.
Hi,
Thanks for the answer, but I don't think the Temp-directory is running out of free space. I have 150 GB of free space on the Temp-directory HDD.
Do you have any other idea?
It works, if I exit SQL Data Compare and start it again.
Thanks, / comments
Hi,
Thanks for the answer, but I don't think the Temp-directory is running out of free space. I have 150 GB of free space on the Temp-directory HDD.
Do you have any other idea?
It works, if I exit ...
Thank you very much for you help. / comments
Thank you very much for you help.
Hi Chris,
Sorry, but it only fixed the issue partially.
I can switch in fullscreen mode, which makes it much easier to navigate in the "Tables & Views" tab. But in the "Object Mapping" tab, I still can not resize the grid of the object names. It's still too small, if you have a lot of tables. [image]
Any chance to get that fixed...
And the drop-down box when you try to change the comparison key is still too small. Some of our key-names are quite long and I have to guess which one is the right one.
Sorry. / comments
Hi Chris,
Sorry, but it only fixed the issue partially.
I can switch in fullscreen mode, which makes it much easier to navigate in the "Tables & Views" tab. But in the "Object Mapping" tab, I still...
Gee... that's quite a long time... :shock: I guess I have to switch back to SQL-Prompt 3.9 which does not have this problem. [image] / comments
Gee... that's quite a long time... :shock: I guess I have to switch back to SQL-Prompt 3.9 which does not have this problem.
Anu Deshpande wrote:
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.
Hi,
I was wondering if there is a time schedule for this error to be fixed? / comments
Anu Deshpande wrote:
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 f...
Hi,
you are absolutly right. Escpecially that the problem also occures with the keyword modify... [image] :shock:
I hope redgate will have a solution very soon. / comments
Hi,
you are absolutly right. Escpecially that the problem also occures with the keyword modify... :shock:
I hope redgate will have a solution very soon.
Anu Deshpande wrote:
Apologies that the suggestion didn't help.
Can you send us the complete query so that we can understand the scenario and replicate the issue?
Here is a sample code:
DECLARE @XML XML
SET @XML = (SELECT ID
, LastName
, FirstName
FROM ( SELECT 1 AS ID
, 'LastName1' AS LastName
, 'FirstName1' AS FirstName
UNION
SELECT 2 AS ID
, 'LastName2' AS LastName
, 'FirstName2' AS FirstName
UNION
SELECT 3 AS ID
, 'LastName3' AS LastName
, 'FirstName3' AS FirstName) AS NameList
FOR XML AUTO, TYPE
)
SELECT T.C.VALUE('@ID', 'INT') AS ID
, T.C.VALUE('@LastName', 'NVARCHAR(100)') AS LastName
, T.C.VALUE('@FirstName', 'NVARCHAR(100)') AS FirstName
FROM @XML.nodes('/NameList') T(C)
If I execute the code I get the error message:
Msg 227, Level 15, State 1, Line 21
"VALUE" is not a valid function, property, or field.
"value" is case sensitive and must be in lower case. SQLPrompt changes the value always to upper case.
It must look like this:
SELECT T.C.value('@ID', 'INT') AS ID
, T.C.value('@LastName', 'NVARCHAR(100)') AS LastName
, T.C.value('@FirstName', 'NVARCHAR(100)') AS FirstName
FROM @XML.nodes('/NameList') T(C)
/ comments
Anu Deshpande wrote:
Apologies that the suggestion didn't help.
Can you send us the complete query so that we can understand the scenario and replicate the issue?
Here is a sample code:
DECLAR...
Hello Anu,
that does not help at all. [image]
It works for the word'value but all the other keywords are kept in the case i'm typing them in.
That's not helpful. All other keywords, function and data-types are needed in upper case.
So i have to keep these settings with uppercase.
I don't understand why value is changed to upper case. It's not a reserved keyword, or a function or a data-type?
Sorry, but this solution makes it worse. [image]
Thanks.
Thorsten / comments
Hello Anu,
that does not help at all.
It works for the word'value but all the other keywords are kept in the case i'm typing them in.
That's not helpful. All other keywords, function and data-type...
I sent you the script per email... / comments
I sent you the script per email...