SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Syntax Check incorrectly flags WITH LOG as Unused Variable

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Syntax Check incorrectly flags WITH LOG as Unused Variable
Author Message
anildas



Joined: 14 Nov 2007
Posts: 69
Country: United States

Post Syntax Check incorrectly flags WITH LOG as Unused Variable Reply with quote
TSQL:
Code:
RAISERROR(@ErrorMessage, @ErrorSeverity, @ErrorState) WITH LOG;

SQL Assistant Syntax Check:
Code:
Unused variable LOG

Fri Mar 09, 2012 1:17 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
Hi. I'm unable to reproduce. Which version of SQL Assistant are you running?
Is the referenced line belong to a standalone T-SQL block or to some stored procedure?

Can you please post the complete script?
Fri Mar 09, 2012 1:29 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
It's the same here. The script is complete except for variable declarations. Nothing else is in editor just those two lines of code. SA shows the following warning after the check:


Fri Mar 09, 2012 5:00 pm 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.