>
> Commit the ALTER, then do the DML statement.
>
> That should fix it.

Did this and it doesn't work.

> > Is this as designed or could it be a bug? Actually, I'm not even sure if
>
> Well, kind of " as designed " ... -> mixing DDL and DML isn't really
> supported. IMO, it should simply raise an exception if you DML something
> into not yet comitted DDL. That would solve the immediate problem of
> unpredictable results and it would be clear it's not supported.
>

They shouldn't "normally" be mixed but it shouldn't cause this kind of
problem. As a further test, I directed the IB_Connection component to point
to my IB server instead of local for embedded FB. That should redirect the
local gds32.dll (FB) to act as a client and it did. When I run the mixed
DDL/DML on that setup, it works as expected, updating the correct field.

I would consider this a bug in embedded. Does that sound reasonable?

Woody (TMW)