search

Jeff-Lewis / codesmith

Automatically exported from code.google.com/p/codesmith
0 stars 0 forks source link

Stored Procedures report Parameter not set if the Parameter has an undescore in it. #132

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Create a SP with a variable containing an underscore like @My_Parameter
2. Create Outputs.
3. Call the SP

What is the expected output? What do you see instead?

SQL is expecting the Parameter in the way it was written in TSQL, so the 
default "Clean Expression" ( ^\\w+_ ) setting should not be taken for SP-
parameters.

What version of the product are you using?

Latest.

Please provide any additional information below.

How to change the "Clean Expression" ( ^\\w+_ )to include underscore?
Just removing it doesn't help. I had to rename my Parameters inside the SP 
and re-generate the outputs and then it worked. (But I can't rewrite all 
SP's for other projects)

Original issue reported on code.google.com by schaffn...@GMX.de on 1 Sep 2009 at 10:42

GoogleCodeExporter commented 9 years ago

Original comment by shannon....@gmail.com on 4 Sep 2009 at 4:14