Not Recomended Usage UDF Scalar Into

[former_member587347]

Hello,

I have this function :

CREATE FUNCTION "HS_DVTutar"( 
 Dv DECIMAL(18,6),
 donembasi DATE,
 donemsonu DATE
 )
 RETURNS result DECIMAL(18,6)
 LANGUAGE SQLSCRIPT
 SQL SECURITY DEFINER
 AS
 BEGIN
 DECLARE ret decimal(18,6); 
SELECT Top 1 "U_DVOran" into ret  FROM "@HS_DVORAN"  WHERE "U_BasTarih" <= donembasi AND "U_BitTarih" >= donemsonu ORDER BY "U_BasTarih" Desc;
      SELECT IFNULL((ret / 100.00 * :Dv),0)
         INTO result FROM DUMMY;
 RETURN;
 END

When code run in SAPA HANA directly, it is work. However, I am using the function in VS2013 with DoQuery and I have this error: "Not Recommended Using Select Into Scalar UDF