Subject using DDL and DML in one transaction in FB
Author vojtech.vild
Hi all!

Is is possible in the Firebird to add new column and update value of
this column in one transaction (I am moving app from PostgreSQL to FB)?


ALTER TABLE action ADD speedmod INTEGER;
UPDATE action SET speedmod = 1;

Firebird output:
SQL error code = -206
Column unknown
At line 2, column 19

PostgreSQL output: