UniCommandBuilder.DeriveParameters Method does not wrok!

UniCommandBuilder.DeriveParameters Method does not wrok!

Postby nickcole » Sun 20 Mar 2011 09:58

When I use UniCommandBuilder.DeriveParameters Method. It does not work!
Error Information:
A parameter with name '@RETURN_VALUE' is not contained by this Parameters collection.
my Code:
Code: Select all
      Dim myConn As UniConnection = New UniConnection("Provider=SQL Server;User Id=sa;Password=hhzstsll;Data Source=IBM008;Database=pubs")
        myConn.Open()

        Dim includeReturnValueParameter As Boolean = False

        Dim spName As String = "byroyalty"
        Dim cmd As UniCommand = New UniCommand(spName, myConn)
        Dim discoveredParameters() As UniParameter


        cmd.CommandType = CommandType.StoredProcedure
        UniCommandBuilder.DeriveParameters(cmd)
        If Not includeReturnValueParameter Then
            cmd.Parameters.RemoveAt(0)
        End If

        discoveredParameters = New UniParameter(cmd.Parameters.Count - 1) {}
        cmd.Parameters.CopyTo(discoveredParameters, 0)


Devart.Data.Universal 3.20.42.0
MS SQL Server 2005 DB:pubs
VS2010 10.0.3.3019.1 RTMRel
:?:[/quote]
nickcole
 
Posts: 7
Joined: Sat 19 Mar 2011 01:03

Postby Shalex » Mon 21 Mar 2011 15:22

We have reproduced the issue. We will investigate it and notify you about the results as soon as possible.
Shalex
Devart Team
 
Posts: 7777
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Mon 21 Mar 2011 17:32

The bug is fixed. I will post here when the corresponding build is available for download.
Shalex
Devart Team
 
Posts: 7777
Joined: Thu 14 Aug 2008 12:44

Postby nickcole » Tue 22 Mar 2011 12:23

OK. I wait for the new version!
Shalex wrote:The bug is fixed. I will post here when the corresponding build is available for download.
nickcole
 
Posts: 7
Joined: Sat 19 Mar 2011 01:03

Postby Shalex » Fri 25 Mar 2011 13:16

New build of dotConnect Universal 3.20.44 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/univer ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ .
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=20590 . This build also includes the fix for the bug with the UniCommandBuilder.DeriveParameters() method.
Shalex
Devart Team
 
Posts: 7777
Joined: Thu 14 Aug 2008 12:44

Postby nickcole » Sat 26 Mar 2011 12:47

thank you!
I have download "dotConnect Universal 3.20 Standard (Free)". It does not update.

Shalex wrote:New build of dotConnect Universal 3.20.44 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/univer ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ .
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=20590 . This build also includes the fix for the bug with the UniCommandBuilder.DeriveParameters() method.
nickcole
 
Posts: 7
Joined: Sat 19 Mar 2011 01:03

Postby Shalex » Mon 28 Mar 2011 08:28

Thank you for your report. We have updated the download links at http://www.devart.com/dotconnect/universal/download.html. Please try again and notify us about the results.
Shalex
Devart Team
 
Posts: 7777
Joined: Thu 14 Aug 2008 12:44

Postby nickcole » Tue 29 Mar 2011 11:37

greate! It's OK!
thank you!

Shalex wrote:Thank you for your report. We have updated the download links at http://www.devart.com/dotconnect/universal/download.html. Please try again and notify us about the results.
nickcole
 
Posts: 7
Joined: Sat 19 Mar 2011 01:03


Return to dotConnect Universal