Latest version

Oct 16, 2012 at 12:03 PM

Dave,

The latest version is fabulous! Definitely something I'm going to Tweet about.

Doug

Oct 16, 2012 at 12:24 PM
Edited Oct 16, 2012 at 12:26 PM

OK - so I want to use it to evaluate my SQL stored procedures.

So my base directory is C:\TSQLT\Parser. My stored procedures are in the subdirectory Mine eg C:\TSQLT\Parser\Mine.

I try .\Mine, C:\TSQLT\Parser\Mine - I get the following

Get-Content : Access to the path 'C:\' is denied.

At C:\tsqlt\parser\TSQLSmells.ps1:116 char:12

+     $TextIn = Get-Content $FileName+               ~~~~~~~~~~~~~~~~~~~~~    + CategoryInfo          : PermissionDenied: (C:\:String) [Get-Content], UnauthorizedAccessException   

+ FullyQualifiedErrorId : GetContentReaderUnauthorizedAccessError,Microsoft.PowerShell.Commands.GetContentCommand

Exception setting "SelectedIndex": "InvalidArgument=Value of '0' is not valid for 'SelectedIndex'.

Parameter name: SelectedIndex"

At C:\tsqlt\parser\TSQLSmells.ps1:131 char:2

+     $SmellListBox.SelectedIndex =0

+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~   

+ CategoryInfo          : NotSpecified: (:) [], SetValueInvocationException   

+ FullyQualifiedErrorId : ExceptionWhenSetting

Any ideas?

Thanks,

Doug

Coordinator
Feb 17, 2013 at 9:42 AM
Edited Feb 17, 2013 at 9:42 AM
Hi Doug,

Thanks for the feedback , sorry for the delay , I didn't notice these :S
Hope you have resolved your issues, glad you like it

Dave