Hi -

After dropping a column in a table (using TIB_DSQL. ExecuteDDL) and posting to the table, I get this EIBO_ISCError

ISC ERROR CODE:335544865
ISC ERROR MESSAGE: Column has been unexpectedly deleted
STATEMENT: LogTable12.<no name>(TIBOInternalDataset)

What I don't understand is that my TIBOTable component doesn't refer to the dropped field.

Before dropping the field, the table has been posted to, but in the mean time it has been closed and the TIBOTable freed. The error arises in a newly created TIBOTable component.

There must be some sort of caching going on, but looking at TIBODatabase.SchemaCache.TableFields, the dropped field doesn't show up here, and doing TIBODatabase.FlushSchemaCache or TIBODatabase.SchemaCache.InvalidateAllItems doesn't help either.

The only thing that I've found to work is

TIBODatabase.Disconnect;
TIBODatabase.Connect;

I'd like to understand what's going on here :-)

Thanks
Jacob