Stored Procedures --> Functions

[Ruslan Zasukhin]

On 3/9/07 8:12 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

> Ruslan, you are truly unbelievable.

I'd say not me, but the Valentina team :)
In particular Ivan will try solve your request.
 
> Big thanks.
> 
> 
> I suppose you mean that you will implement the first step  (returning
> a single argument of primitive datatype) ?

First step yes.

> Or do you see a possibility to make it return cursors also ?
> If this is not possible do you think we can expect stored functions
> returning cursors in a following release ?

Ivan says that it seems not hard  -- for procedures.

For User Defined Functions I do not think it is good idea,
    because such functions must also work e.g. In the SELECT, right?

So UDF should return just scalar value: INT, STRING, DATE, NULL, ...
    as any other existed Valentina function.

-
Procedures will be able return cursor via OUT parameter.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]