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

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

> Ask microsoft ;), the only reasin i see for this is that they use
> FbDatareader.NextResult to process batch commands ;)

Thanks for answer. I understand what happened :)
But a still have problem :(

I changes my TEST_DELETE stored procedure (return integer 345):
------------------------
SET TERM ^ ;

CREATE PROCEDURE TEST_DELETE (
    ID BIGINT)
RETURNS (
    "OUTPUT" INTEGER)
AS
BEGIN
    delete from test where :ID = ID;
    OUTPUT = 345;
    suspend;
END^

SET TERM ; ^
------------------------

Exception gone, all ok, but changes not commited :(

/~~~~~/
// Delete first row.

DataRow row = table.Rows[0];

row.Delete();

FbCommand deleteCommand = new FbCommand("\"TEST_DELETE\"", connection,
transaction);

deleteCommand.CommandType = CommandType.StoredProcedure;

FbCommandBuilder.DeriveParameters(deleteCommand);

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

adapter.DeleteCommand = deleteCommand;

// row.RowState = Deleted     !!!!!!!!!!!!!!!!!!!!!!!!!!!

adapter.Update(table);

// row.RowState = Detached !!!!!!!!!!!!!!!!!!!!!!!!!!

transaction.Commit();

/~~~~~/
When i see table in my database - i see this row, it not deleted.

Why?