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