SQL Anywhere database

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

RAMENCAS

2005-10-27, 7:41 am

How can I create a function that return a value from a table

--
Rafael Antonio Mendoza Castillo
ramencas@softwaredev
enezuela.com
ramencas@gmail.com

Solo MSN: ramencas@hotmail.com

Breck Carter [TeamSybase]

2005-10-27, 7:41 am

On 25 Oct 2005 16:26:12 -0700, "RAMENCAS"
< ramencas@softwaredev
enezuela.com> wrote:

>How can I create a function that return a value from a table

CREATE FUNCTION fff()
RETURNS INTEGER
BEGIN
DECLARE @return_value INTEGER;
SELECT AVG ( row_num )
INTO @return_value
FROM RowGenerator;
RETURN @return_value;
END;

SELECT fff();

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Sponsored Links