Submitted by: ibrahim bulut (ibrahim_bulut)

hi all,
i have using firebird since 2000. i have two big application written with delphi and firebird. one of them is firebird 1,0 and another is firebird 1,5. i am planning to upgrade them firebird 2,0.

i have a request. i use udf but sometimes udf library crash the server (not always, sometimes). i think this problems about windows problem. i need a database function i.e dbfunction like an udf. but this function dos not use a dll library. this function stored in the database and function has an output value. like sqlserver functions and delphi functions.

sql server functions work three different ways
1-scalar function (like a delphi function)
2-table value function
3-multi statement table value function

i can do 2 and 3 with stored procedure. first status is an udf.
in fact, the problem is about the views and stored procedures.
i use views generally. but view can not use a stored procedure.
i returns a field and a row from sp but sp can not use with a view.
so, i am writting an udf and upgrade my customers system. this is too costly.

in fact, i want to a udf function for using with views but not in a dll library file.

also, why i can not use stored procedures with views please explain me.