Cursors & Stored Procedures

[Claudius Sailer]

Am 14.07.2007 um 09:36 schrieb Ivan Smahin:

> Hello Bart,
>
> Friday, July 13, 2007, 12:16:40 PM, you wrote:
>
> BP> Hi List,
>
> BP> Do I understand correctly that there is no way to make a stored
> BP> procedure return a cursor to the calling application.
> BP> In other words I cannot do this:
>
>
> BP> Dim Cur1 as Vcursor
>
> BP> call myStoredProcedure(Cur1)
>
>
> BP> if Cur1 <> Nil Then
> BP>         .....
> BP> end if
>
> Right you can not.
>
> BP> I really would love this functionality. It makes it possible to  
> move
> BP> much more intelligence to the backend thus simplifying the
> BP> development of the interfaces.
>
> Would you like put it as feature request to the Mantis?

But don't forget, that it should be possible to set parameters. So it  
would be better somehting like this

Cur1 = myStoredProcedure(Prameter1, Parameter2, Parameter3)


bye


Claudius

-- 
iMac CD 2GHz / MacOS X 10.4.8de / RB 2007r3/ Valentina 2.5.8
Homepage    http://www.ClaSai.de
iChat        ryhoruk
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]