VS2005 DataSet Designer and MySQL Functions

VS2005 DataSet Designer and MySQL Functions

Postby bunton » Fri 06 Jul 2007 20:15

Hello everyone, I'm having a little problem using the VS2005 DataSet designer with MySQL functions.

Let's say I have defined the following MySQL function:

Code: Select all
create function ProductFunc(double num1, double num2) returns double
begin
     return num1 * num2;
end


Now, I go to my DataSet designer in VS2005, and attempt to add the function to the auto-generated TableAdapter:

    1) Right-click on table adapter, select Add Query
    2) Select Use existing stored procedure
    3) Select ProductFunc from the dropdown provided


When I select the function, none of the parameters are listed. This is fine as its trivial for me to add them manually (I just select the function from the designer, click Properties and modify the Parameters collection.

However, when I save the dataset, I notice that the return value of function is of type string, when it should be double.

Is there something I'm doing wrong here?

Sincerely,
bunton
bunton
 
Posts: 7
Joined: Wed 07 Feb 2007 19:40

Postby Alexey » Mon 09 Jul 2007 07:53

We will investigate this problem.
Look forward to hearing from me again.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Alexey » Wed 11 Jul 2007 15:11

The problem appears to be complicated, and finding a solution may take a lot of time. Until then you can fix it manually updating *.xsd file (changing Object to Double).
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby bunton » Thu 02 Aug 2007 16:55

Thanks for the response. Any idea when this might be fixed? It's not that big a deal but it would be nice if it worked correctly.

Thanks,
bunton
bunton
 
Posts: 7
Joined: Wed 07 Feb 2007 19:40

Postby Alexey » Fri 03 Aug 2007 08:28

This is minor bug, as you understand. At once it is quite involved with regards to fixing it.
So please be warned that providing a solution will take much time and plan your development strategy accordingly.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL