Sorry if this is slightly off-topic but I can't find a specific forum
for the ado.net provider.

I can't get an FbCommand.ExecuteNonQuery() to return the number of
rows affected when at the very *least* it should return 0 if none were
affected.

In Sql Server I can get this to work w/o a problem but I get an error
telling me "Specific cast is not valid" when trying to return an
integer, for example (C#):

FbCommand fbComm = new FbCommand(query, conn);
fbComm.CommandType = CommandType.StoredProcedure;

...

int retSelValue = fbComm.ExecuteNonQuery();

I can walk through the code and it behaves exactly as expected until
it reaches the "Execute..." line.

I converted this code from SqlCommand to FbCommand and it worked fine
against SqlServer, just as expected.

Any ideas?

Thanks!