stored procedures in local database

Danny Lewkin daniel.lewkin at cognosis.be
Mon Oct 1 03:05:47 CDT 2007


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

Greetz,

Danny





More information about the Valentina mailing list