Re: [Firebird-net-provider] Custom Data Adapter

[<car...@te...>]

Hello:

> I would like to see FbDataAdapter fixed so that it works with FbCommand 
> objects that are stored procedures, but it may be that this isn’t doable 
> without some modifications to the Firebird database itself.

As we have talkign about this privately i'm going to comment where is 
the problem and i'm going to reproduce here the last email i have sent 
to you :).

The problem relies in that DbDataAdapter.Update is not calling 
FbDataReader.Read method for delete commands.

Now the fix that i think can solve this, and that i have sent yet to 
your private email:

Maybe there are one way, the Close method of the FbDatareader needs to 
fill output parameters values, we can try to make a call to the Read 
method if the DataReader is in the original position ( and the 
CommandType is an stored procedure and the statement is a select ), 
before call InternalSetOutputParameters .... this can be an option, i 
will try to check it.



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain