Using Firebird embedded 2.0.1 and 27th Oct 2006 Data Provider for .NET 2.0
When using stored procedures via the EXECUTE PROCEDURE statement,
ExecuteNonQuery does not seem to be returning the number of rows affected.
CommandType is set to Text then ExecuteNonQuery returns 0, if set to
StoredProcedure it returns -1. We're using NHibernate with Firebird
embedded and it throws exceptions if rows affected is not 1.
Is there something I need to set on the database/provider/store proc to
allow this value to be returned correctly.
// example code
System.Data.IDbCommand command = connection.CreateCommand();
command.CommandText = "EXECUTE PROCEDURE
COMMENTINSERT('89E67E6D-B44E-42A9-ADB6-C2113AF6DFB7', 'my test comment',
NULL, NULL, 'me', '12345678', 'DEB79C03-CC5A-4BAF-96E3-DBB1D794D60C');";
command.CommandType = System.Data.CommandType.Text;
int rowsAffected = command.ExecuteNonQuery();
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
