Fatal Error Occurs while declaring Local variable in MYSQL using C#

Question

I am getting an exception while declaring the local variable in MYSQL. Please suggest me how to solve the issue..

Exception:
Fatal error encountered during command execution.
InnerException:
{"Parameter '@OrderofParent' must be defined."}

Code Snippit:

   StringBuilder sbQuery = new StringBuilder(); <br>
    sbQuery.Append(@"Declare @OrderofParent INT; SET @OrderofParent = 0;
                    select top 1 @OrderofParent = OrderofParent from Filter group        by          OrderofParent order by OrderofParent desc;

    select 'FamilyType' as Mode, 0 as Id, 'Complexity Type' as FilterName, null as FilterCreatedDate, 0 as IsDisabled,0 as ParentId,                                               @OrderofParent as OrderofParent,1 as TagDisplay, 0 as ParentCount from I_FamilyTypePrice
union
Select 'Filter', Id, FilterName, FilterCreatedDate, IsDisabled, f.ParentId, OrderofParent, TagDisplay, 0 from Filter f where f.ParentID = 0 
union
select 'FamilyType', ft.Id, FamilyTypeName, CreatedDate, 0,0, @OrderofParent,0, count(complexityType) from I_FamilyTypePrice ft join Family f on f.complexityType = ft.Id where version = @version and IsActive = 1 and Uploaded = 1; ");

Where's the code that actually calls mySQL?

dbugger
– dbugger

2014-02-07 04:31:47 +00:00
Commented Feb 7, 2014 at 4:31 — dbugger
– dbugger, Commented Feb 7, 2014 at 4:31

Vignesh Kumar A · Accepted Answer · 2014-02-07 04:33:06Z

1

ADD "Allow User Variables=True" in the connection string parameter

answered Feb 7, 2014 at 4:33

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Fatal Error Occurs while declaring Local variable in MYSQL using C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related