I am developing a module, I created the database script and tried to run it in Host > SQL .
I am getting the errors , then for testing purpose I tried to create a very simple procedure, but error was there.
I watched the Task Manger video and where presenter is using Host >SQL page to run the script.
After googling the solution, I couldn't fine anything , but the Charles Nurse suggestion that we should use the wildcard character.. but what if I am supplying the parameters ?,
As the above post also suggested that there is some issue with petapoco engine.. but I am afraid
A simple example and result is here:
Create Procedure Test1
@a int,
@b int
AS
Select '1'
System.ArgumentException: Parameter '@a' specified but none of the passed arguments have a property with this name (in '
Create Procedure Test1
@a int,
@b int
AS
Select '1'')
at PetaPoco.Internal.ParametersHelper.<>c__DisplayClass1.<ProcessParams>b__0(Match m)
at System.Text.RegularExpressions.RegexReplacement.Replace(MatchEvaluator evaluator, Regex regex, String input, Int32 count, Int32 startat)
at System.Text.RegularExpressions.Regex.Replace(String input, MatchEvaluator evaluator)
at PetaPoco.Internal.ParametersHelper.ProcessParams(String sql, Object[] args_src, List`1 args_dest)
at PetaPoco.Database.CreateCommand(IDbConnection connection, String sql, Object[] args)
regards,
RA