Helen said:
"...in Firebird 2.0, you will get an exception if you try to double-hit the
same record. This should pre-empt these Invalid Blob ID errors (along with
Too Many Savepoints error) in DSQL at least, although I think it is still
possible to get them in a carelessly designed trigger or SP."

This greatly concerns me. I don't believe Firebird should restrict the
client's activities in such a way that a record may only be updated once in
a transaction. This is both unnecessary and impractical to work around such
a limitation in the core engine. I can't believe such a limitation is being
imposed and so I'd like some kind of clarification on this.

Regards,
Jason Wharton