Stored Procedures --> Functions

[Bart Pietercil]

On 3-sep-07, at 19:56, Ruslan Zasukhin wrote:

> 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.
>

That's all I need

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

of course

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

agree

> -
> Procedures will be able return cursor via OUT parameter.

That will be THE most usefull addition to procedures I can imagine.
It will make it possible to build applications in Valentina, where  
only the interface will be in a different language.
It will reduce the development time exponentially when an application  
needs multiple interfaces (web, client server,...)

Of course the problem now is I can hardly wait.
If Ivan likes beer, tell him I sent him a whole barrel of Belgiums  
Finest (300+ to choose from), of course after completion because his  
head WILL hurt when he stops drinking :-)

thx

Bart