> 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.

Is this your SQL? Are you makeing changes tothe system table? Or is this SQL
unknown to you and created by IBExpert?
If you are indeed manipulating the system tables - what are you doing to
them?

If this is not generated by you - then I would recommend as a first step, to
do a backup and restore.
Alan