stored procedures in local database

[Ruslan Zasukhin]

On 1/10/07 11:05 AM, "Danny Lewkin" <daniel.lewkin at cognosis.be> wrote:

Hi Danny,

> Hi list,
> 
> in a local database, i have this stored procedure:
> 
> create or replace procedure conn_listconnections()
> BEGIN
> SELECT RecID, bookmark_name, remote, location, dbname, portnr,
> settings_path, last_connected FROM tbl_connection ORDER BY
> bookmark_name;
> END
> 
> In RB i want to create a new cursor with a call to this procedure, so
> i do it like this:
> 
>      strQuery = "CALL conn_listconnections()"
>      MyCursor = new VCursor(MyConnectionDB, strQuery,
> EVCursorLocation.kClientSide, EVLockType.kNoLocks,
> EVCursorDirection.kForwardOnly)
> 
> But I don't get any records in the Cursor...
> When I call the stored procedure in VStudio, I get 2 records...

What version of Valentina ?
Ability return cursor by CALL was added into 3.4 only.


I don't understand also
    if 3.x still support form of Vcursor ( query ) ?

Recommended way is 

    curs = db.SqlSelect( "CALL ... " )   if you want cursor

Or 

    db.SqlExecute( "CALL proc" ) if just procedure



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