Error running Stored Procedure: because the function is valued function object
1 July, 2017
Updated documentation can now be found via our YF community HERE
Hi Mentor,
Yellowfin should be able to use a stored procedure that returns a table, a situation where a stored procedure won't work is when the table name is passed into the SP, for example, SELECT * FROM @tablename.
Regarding Transact-SQL, Yellowfin only supports single statement queries, I can't say whether this might be causing you to get that error without seeing your stored procedure, so can you please paste your SP (or attach it) to this post, and also tell us which database you are using.
Regards,
Dave
Yellowfin should be able to use a stored procedure that returns a table, a situation where a stored procedure won't work is when the table name is passed into the SP, for example, SELECT * FROM @tablename.
Regarding Transact-SQL, Yellowfin only supports single statement queries, I can't say whether this might be causing you to get that error without seeing your stored procedure, so can you please paste your SP (or attach it) to this post, and also tell us which database you are using.
Regards,
Dave
I was trying to use YF to call a custom function that returns a table type.
This is what the function look like:
[code]CREATE Function ufnGetRateReport (@StartDate DateTime, @EndDate DateTime)
RETURNS @ResultSet TABLE
(
[RecordDate] DateTime,
[Value] int,
[Duration] DateTime
) AS
BEGIN
...
END
[/code]
I managed to work around the issue by creating a stored procedure wraps the function call
[code]
CREATE PROCEDURE uspGetRateReport(@StartDate DateTime, @EndDate DateTime)
AS
SELECT RecordDate, Value, Duration
FROM ufnGetRateReport(@StartDate, @EndDate)
[/code]
This is what the function look like:
[code]CREATE Function ufnGetRateReport (@StartDate DateTime, @EndDate DateTime)
RETURNS @ResultSet TABLE
(
[RecordDate] DateTime,
[Value] int,
[Duration] DateTime
) AS
BEGIN
...
END
[/code]
I managed to work around the issue by creating a stored procedure wraps the function call
[code]
CREATE PROCEDURE uspGetRateReport(@StartDate DateTime, @EndDate DateTime)
AS
SELECT RecordDate, Value, Duration
FROM ufnGetRateReport(@StartDate, @EndDate)
[/code]
Hi Mentor,
That is a clever work around :).
Unfortunately that's the only way to return the table type at this point in time.
We have gone ahead and raised it as an enhancement request so something we can hopefully support in the future.
Apologies for the inconvenience this has caused.
Regards,
David
That is a clever work around :).
Unfortunately that's the only way to return the table type at this point in time.
We have gone ahead and raised it as an enhancement request so something we can hopefully support in the future.
Apologies for the inconvenience this has caused.
Regards,
David