Process RETURNING and SP output
-------------------------------

                 Key: DNET-319
                 URL: http://tracker.firebirdsql.org/browse/DNET-319
             Project: .NET Data provider
          Issue Type: Task
          Components: ADO.NET Provider
            Reporter: Konstantin Dombrugov
            Assignee: Jiri Cincura


FirebirdClient does not return output of statements with "RETURNING" and I 
suspect that SP too.
I've fixed this issue for me but maybe there's a better way and imho this 
should be in official version.

Solution:
Data\Client\Managed\Version10\GdsStatement.cs
in public override DbValue[] Fetch()
replace 
                                        if (this.statementType != 
DbStatementType.Select &&
                                this.statementType != 
DbStatementType.SelectForUpdate)
                        {
                                return null;
                        }
with
                                        if (this.statementType != 
DbStatementType.Select &&
                                this.statementType != 
DbStatementType.SelectForUpdate)
                        {
                                                     if (this.StatementType == 
DbStatementType.StoredProcedure && !allRowsFetched)
                                                     {
                                                                  
allRowsFetched = true;
                                                                  return 
this.GetOutputParameters();
                                                     }
                                return null;
                        }

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

        

------------------------------------------------------------------------------

_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to