VS2005 DataSet Designer and MySQL Functions

bunton · Post by **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

Alexey · Post by **Alexey** » Mon 09 Jul 2007 07:53

We will investigate this problem.
Look forward to hearing from me again.

Alexey · Post by **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).

bunton · Post by **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

Alexey · Post by **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.