Category
Data Sources
Error running Stored Procedure: because the function is valued function object
Resolved
Hi, I have created a function that returns a table, but when I try to use it in YellowFin, I got the following error:
Error running Stored Procedure: The request for procedure ‘GetMILStateReport’ failed because ‘GetMILStateReport’ is a table valued function object.
Does this feature support? What do I need to do to return a result set from a T-SQL?
The same problem 
Yellowfin only supports single statement queries, and does not support creating functions.
E.g. If you were using something like this:
It would give you that function object error.To get around this, you will need to wrap the function in a SP, then call the SP from within YF.
If you still face issues, please let us know.
Regards,
David
Yellowfin only supports single statement queries, and does not support creating functions.
E.g. If you were using something like this:
It would give you that function object error.To get around this, you will need to wrap the function in a SP, then call the SP from within YF.
If you still face issues, please let us know.
Regards,
David
Replies have been locked on this page!