stored procedures in local database

[Danny Lewkin]

That was the trick, still had the old version of the RB plugin, now  
it works...
Do you mean that I can not use the class-way creation of a cursor? Do  
i need to rewrite is all to DB.sqlselect..??

Op 1-okt-07, om 12:19 heeft Ruslan Zasukhin het volgende geschreven:

> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina