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
- 1) Right-click on table adapter, select Add Query
2) Select Use existing stored procedure
3) Select ProductFunc from the dropdown provided
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?