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