Subject | using DDL and DML in one transaction in FB |
---|---|
Author | vojtech.vild |
Post date | 2007-06-28T12:01:12Z |
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)?
Example:
ALTER TABLE action ADD speedmod INTEGER;
UPDATE action SET speedmod = 1;
Firebird output:
SQL error code = -206
Column unknown
SPEEDMOD
At line 2, column 19
PostgreSQL output:
OK
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)?
Example:
ALTER TABLE action ADD speedmod INTEGER;
UPDATE action SET speedmod = 1;
Firebird output:
SQL error code = -206
Column unknown
SPEEDMOD
At line 2, column 19
PostgreSQL output:
OK