Devart Forums

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:
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

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

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).

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

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.