Re: [Firebird-net-provider] FbDataAdater.Update()

[olegmad <ol...@ya...>]

> > adapter.Update(table);         // EXCEPTION HERE !!!!!!!!!!!!!!!!
>
> This will call FbCommand.ExecuteReader method, the provider will
> transform the command text into:
>
> select * from "TEST_DELETE"
>
> As TEST_DELETE has no return values firebird will throw an exception.
>
> You can try using EXECUTE PROCEDURE sintax, or returning at least one
> value ( for example the number of rows affected ;) )

In my example i use deleteCommand for call stored procedure which delete
data. How provider may call select * from "TEST_DELETE"???

------------------
FbCommand deleteCommand = new FbCommand("\"TEST_DELETE\"", connection,
transaction);
deleteCommand.CommandType = CommandType.StoredProcedure;

FbCommandBuilder.DeriveParameters(deleteCommand);

deleteCommand.Parameters[0].SourceColumn = "ID";

adapter.DeleteCommand = deleteCommand; /// !!!!!!!!!! it's NOT select stored
procedure !!!!!!!!!!

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

I am waiting your feedback. :)