 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
anildas
Joined: 14 Nov 2007 Posts: 69 Country: United States |
|
Syntax Check incorrectly flags WITH LOG as Unused Variable |
|
TSQL:
 |
 |
RAISERROR(@ErrorMessage, @ErrorSeverity, @ErrorState) WITH LOG; |
SQL Assistant Syntax Check:
 |
 |
Unused variable LOG |
|
|
Fri Mar 09, 2012 1:17 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
|
|
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 |
|
 |
|
|
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
|
|
|