Re: [Firebird-test] [FB-Tracker] Commented: (DNET-364) Executing Procedure that returns values.

[ISC. V. I. H. C. <vi...@ac...>]

The code has the SUSPEND; part at the end of this procedure, so it supposed that it will returns some row at end of this.

Regards!

Accesscom Comunicaciones S.A. de C.V.
ISC. Victor Israel Herrera Coronado
Departamento de Ingeniería y Desarrollo de Software
Calle 20 # 231 x 13 y 15 Col. Vista Alegre
Telefonos: (999)930 24 90, 930 24 95
Lada sin costo: 01 800 670 62 82
web: www.accesscom.com.mx
blog: www.accesscom.com.mx/blogs
twitter: @accesscom_mx



-----Mensaje original-----
De: Jiri Cincura (JIRA) [mailto:tr...@fi...] 
Enviado el: sábado, 14 de mayo de 2011 10:18 a.m.
Para: vi...@ac...
Asunto: [FB-Tracker] Commented: (DNET-364) Executing Procedure that returns values.


    [ http://tracker.firebirdsql.org/browse/DNET-364?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=23472#action_23472 ] 

Jiri Cincura commented on DNET-364:
-----------------------------------

How the code of SP looks like?

> Executing Procedure that returns values.
> ----------------------------------------
>
>                 Key: DNET-364
>                 URL: http://tracker.firebirdsql.org/browse/DNET-364
>             Project: .NET Data provider
>          Issue Type: Bug
>          Components: ADO.NET Provider
>    Affects Versions: 2.6
>         Environment: C#,Windows 7, Visual Studio 2010, Net Framework 4
>            Reporter: Victor Israel Herrera Coronado
>            Assignee: Jiri Cincura
>
> The problem or issue that I've with the new version of Firebird.Net 2.6. library it's that I can't execute store procedures as I'd usually do with the previous version (2.5). Not produces any kind of error, only the procedure that would output information returns nothing. 
> For example: With C#, Getting a DataSet
> // Supposed m_fb_cnn as a valid FirebirdConnection
> FbAdapter m_fb_ad = new FbAdapter("GET_INFO", m_fb_cnn);
> m_fb_ad.SelectCommand.CommandType = CommandType.StoreProcedure;
> m_fb_ad.SelectCommand.Params.Add("V_PARAM","VALUE");
> // new dataset
> DataSet m_dst = new DataSet();
> // fill dataset
> m_fb_ad.Fill(m_dst);
> It supposed that the dataset wouldn't be empty. With the library 2.5 that not occurs, this functioned very good but in this one (2.6) doesn't function.
> What I do wrong??
> Best regards

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira