Subject | Re: [Firebird-general] MSSQL comparison |
---|---|
Author | Rafael Szuminski |
Post date | 2006-03-05T17:46:14Z |
> With Firebird, it can't happen. Your reports will ALWAYS run.This is not necessarily true. Here is a sure-fire way to block a db/table:
>
> (just a rambling snippet from my experience)
1. Start IBExpert
2. Enter data grid and modify a value in one of the cells
3. Hit the check mark icon in the grid (not the transaction commit button)
4. DO NOT COMMIT the transaction at this time
5. Start a separate application that will use ADO and OleDB driver to
read the table that you just modified
6. ADO application hangs until you commit transaction in IB Expert.
The strange thing is that this only happens with IBExpert. But
nevertheless it is possible to block readers.