Hello,

Don't know if this is IB Expert or Firebird problem. I have a simple
table that when using UPDATE sql everything is fine. However updating
directly with IBExpert this error comes up during commit:

Cannot commit transaction:
Unsuccessful execution caused by an unavailable resource.
size of optimizer block exceeded.


Then simply opening the table with IBExpert throws a database error
as such:

SQL: select rc.rdb$constraint_name,
i.rdb$field_name
from rdb$relation_constraints rc, rdb$index_segments i
where (i.rdb$index_name = rc.rdb$index_name) and
(rc.rdb$constraint_type = 'PRIMARY KEY')
and (rc.rdb$relation_name = 'PM_ORDERS')
order by i.rdb$field_position

Error: Unknown SQL Data type (0).

I cannot open the table again until I exit and restart IBExpert. Can
anyone explain the error message and problem? At least knowing what
the error means may shed some light on the problem. Thanks.