SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Version 12 0 175 - Format error when using CAST function

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Version 12 0 175 - Format error when using CAST function
Author Message
sqltogo



Joined: 02 Jul 2014
Posts: 38
Country: Netherlands

Post Version 12 0 175 - Format error when using CAST function Reply with quote
When SQL files or scripts make use of the CAST function the format option does not work.
Using the command line option it generates an error message.
Exception EAccessViolation in module SqlAssistPrefs.dll at 0000FBE7.
Access violation at address 0810FBE7 in module 'SqlAssistPrefs.dll'. Read of address 6574615F.

A simple example
SELECT CAST ('aaa'

AS

CHAR(10) )

The same SQL code worked fine in version 11.x
Sat Oct 30, 2021 11:15 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Thank you very much for letting us know. We will investigate this issue.
Sat Oct 30, 2021 12:01 pm View user's profile Send private message
sqltogo



Joined: 02 Jul 2014
Posts: 38
Country: Netherlands

Post Reply with quote
At this moment I am working on another workstation I own, where also version 12 is installed.
At this workstation the formatiing works as expected.
This suggest that it is a local issue, maybe not related to the software.
What is the best option to reset all settings and so on to a really default value?
Sat Oct 30, 2021 2:49 pm View user's profile Send private message
sqltogo



Joined: 02 Jul 2014
Posts: 38
Country: Netherlands

Post Reply with quote
Keeps getting stranger, at this workstation formatting works in SQL Assistance editor but not in Management Studio 18.9

SELECT @WarrEndDate =
CASE WHEN @WarrPeriodUnit
= 1 THEN dateadd(yy, CAST(@WarrPeriod AS int), @ShipDate)
WHEN @WarrPeriodUnit
= 2 THEN dateadd(mm, CAST(@WarrPeriod AS int), @ShipDate)
WHEN @WarrPeriodUnit
= 3 THEN dateadd(wk, CAST(@WarrPeriod AS int), @ShipDate)
WHEN @WarrPeriodUnit
= 4 THEN dateadd(dd, CAST(@WarrPeriod AS int), @ShipDate)
END;
Sat Oct 30, 2021 3:46 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Can you please unregister The plugin for the Management Studio, and then reregister it. You can use the Options dialog for that purpose.
Sat Oct 30, 2021 9:37 pm View user's profile Send private message
sqltogo



Joined: 02 Jul 2014
Posts: 38
Country: Netherlands

Post Reply with quote
This does nog help.
I have got mail that your development was also working on it.
Tue Nov 02, 2021 11:25 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
I'm sorry. Working on what?

Have you tried that in Run as Administrator mode?
Tue Nov 02, 2021 11:54 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
The code formatting issue has been fixed in build 12.0.181, that build can be installed using Check for Updates menu
Tue Nov 02, 2021 11:13 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 807
Country: United States

Post Reply with quote
SysOp wrote:
The code formatting issue has been fixed in build 12.0.181, that build can be installed using Check for Updates menu


Checking for updates with 12.0.175 claims there are no updates as of 11/3/21 10:44 Central
Wed Nov 03, 2021 11:44 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Quote:
Checking for updates with 12.0.175 claims there are no updates as of 11/3/21 10:44 Central

There was a minor technical issue on our end making the Check for Updates incorrectly report that there are no updates. The cache has been reloaded and now Check for Updates is able to find build 12.0.181
Wed Nov 03, 2021 10:21 pm View user's profile Send private message
sqltogo



Joined: 02 Jul 2014
Posts: 38
Country: Netherlands

Post Reply with quote
A newer version was released.
I installed it and ran all of my test scripts.
Formatting was completed without issues.
If anyone has simillar problems, updating the software to the latest version will resolve the formatting errors.
Thu Nov 04, 2021 3:45 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Thank you so much for confirming the issue has been resolved.
Thu Nov 04, 2021 10:52 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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
Design by Freestyle XL / Flowers Online.