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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

ISC. Victor Israel Herrera Coronado
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:[hidden email]]
Enviado el: sábado, 14 de mayo de 2011 10:18 a.m.
Para: [hidden email]
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

       


------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its
next-generation tools to help Windows* and Linux* C/C++ and Fortran
developers boost performance applications - including clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Firebird-test mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-test