Bug #29098 TableAdapter Wisard closed wher adding one new (stored procedure)

• Submitted: 14 Jun 2007 6:09
• Modified: 15 Jun 2007 8:37
• Reporter: Psy After
• Status: Closed
• Category: Connector / NET
• Severity: S2 (Serious)
• Version: 5.1.2
• OS: Windows (xp sp2 .net 1.1, 2.0, 3.0)
• CPU Architecture: Any

[14 Jun 2007 6:09] Psy After

Description:
When i try to add new TableAdapter based on stored procedure, so wisard closed without any error

How to repeat:
Add new dataset
go to designer
rigth click-> Add -> TableAdapter 
select connection (or add new)->next
check "Use  existing stored procedure" -> next
select stored procedure from list
after selecting - wizard closed

[14 Jun 2007 13:13] Tonci Grgin

Hi Psy and thanks for another report. Verified as described with MySQL server 5.0.44BK on WinXP Pro SP2 localhost using c/NET 5.1.2 and .NET fw 2.0

If I might add quotation from change log:
  - Fixed problem preventing use of stored procedures for insert, update, and
    delete statements in a table adapter.
Truly, only SELECT causes this behavior. INSERT, UPDATE and DELETE work as expected for me.

[14 Jun 2007 13:28] Psy After

yes, but I need exactly SELECT comand. And SELECT not work
its close wizard:(
all meaning in using SELECT (wizard build tableAdapter bystored procedure)
and INSERT, UPDATE and DELETE I implement by Query(not work too)

[14 Jun 2007 16: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/28784

[14 Jun 2007 16:37] Reggie Burnett

Fixed in 5.1.3

[15 Jun 2007 8:37] MC Brown

A note has been added to the 5.1.3 changelog.