Subject RE: [firebird-support] Error explanation
Author Alan McDonald
> I am in the process of migrating an "old" tool from using ibx
> components to uib components.
>
> When I use the same database (FB 2.0) and script with the ibx
> components, everything's fine. When using uib components I get this
> error when I try to add some column to an existing table:
>
> ALTER TABLE TBLDFUEDATEIAUSWAHL ADD MANERFDATUM DATE
>
> Dynamic SQL Error
> SQL error code = -817
> Metadata update statement is not allowed by the current database SQL
> dialect 1
> The insert, update, delete, ddl or authorization statement cannot
> be executed because the transaction is inquiry only
> Error Code: 249
>
> Can anybody explain this error? Do I have to adjust some transaction
> params/options? If so, which?
>
> --Heiko

I would guess that the IBX script component is set to SET AUTODDL ON and the
UIB component, by default, is not.
Alan