Bug #34941 Tableadapter for a stored procedure doesnt recognize parameters VS2008
Submitted: 28 Feb 2008 20:56 Modified: 1 Mar 2008 10:18
Reporter: Mike Hat Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:5.2.1 OS:Windows (VS2008)
Assigned to: CPU Architecture:Any

[28 Feb 2008 20:56] Mike Hat 
Description:
When adding a tableadapter for a stored procedure it doesnt recognize the parameters. 

I get an error saying:

"Generated SELECT statement
       Parameter '@sarasa' not found in the collection."

for the following stored procedure

PROCEDURE StoredProcedure3 (sarasa int)
BEGIN
SELECT colmena.colmena_id,  apiario.ubicacion FROM colmena  LEFT JOIN apiario ON colmena.apiario_id = apiario.apiario_id WHERE apiario.apiario_id = sarasa;
END

This was working fine on 5.1.4 (after the parameter bugfix)

How to repeat:
Create a stored procedure with a parameter

create a dataset and a table adapter for the stored procedure.
[29 Feb 2008 15:36] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/43225
[29 Feb 2008 15:38] Reggie Burnett 
Fixed in 5.2.2
[1 Mar 2008 10:18] MC Brown 
A note has been added to the 5.2.2 changelog: 

Using the TableAdapter Wizard would fail when generating commands that used stored procedures due to the change in supported parameter characters.