SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Serious $$..$$ macro issues in 6.3.168!!!

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Serious $$..$$ macro issues in 6.3.168!!!
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2109

Post Serious $$..$$ macro issues in 6.3.168!!! Reply with quote
The latest update (6.3.168) has some serious issues when $$..$$ type macros are involved. Many (most) of those I've created are broken. Even those simple ones like this:

Code:

$$
DECLARE   
   @fixed_drives TABLE (
      drive CHAR(1) NOT NULL UNIQUE
      ,[MB free] INT NOT NULL
      ,[GB free] AS CAST([MB free] / 1000.0 as DECIMAL(18,2))
   )
   
INSERT INTO @fixed_drives (drive, [MB free])
EXEC   [master].sys.xp_fixeddrives


SELECT * FROM @fixed_drives ORDER BY drive
$$


When triggering it I get the following error message:
Quote:

Msg 102, Level 15, State 1, Incorrect syntax near 'T'.
The command(s) completed with errors (93.01 ms).


Or:
Code:

$$
SELECT
   cl.ID
   ,cl.DatabaseName
   ,cl.Command
   ,cl.CommandType
   ,cl.StartTime
   ,cl.JobTime
   ,cl.EndTime
   ,cl.ErrorNumber
   ,cl.ErrorMessage
   ,cl.SchemaName
   ,cl.ObjectName
   ,cl.ObjectType
   ,cl.IndexName
   ,cl.IndexType
   ,cl.StatisticsName
   ,cl.PartitionNumber
   ,cl.ExtendedInfo
FROM
   gemdba.dbo.CommandLog AS cl
WHERE   1 = 1
   AND   cl.ErrorNumber <> 0
ORDER BY
   cl.ID DESC
$$


Result:
Quote:

Msg 207, Level 16, State 1, Invalid column name 'Commandcl'.
The command(s) completed with errors (81.37 ms).

... and so on.
Could you provide a download link to the previous version, please?
Mon Dec 03, 2012 5:17 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7854

Post Reply with quote
Thank you for your continues and valuable feedback. We have sent you a link for the private build 6.3.170. Please let us know if you can reproduce the same issue in that build.
Mon Dec 03, 2012 1:32 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2109

Post Reply with quote
SysOp wrote:
Thank you for your continues and valuable feedback. We have sent you a link for the private build 6.3.170. Please let us know if you can reproduce the same issue in that build.

I cannot reproduce them. $$...$$ macros back to normal. Thank you very much for the quick fix.
Tue Dec 04, 2012 4:34 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.