Code: Select all
insert into my_table (avalue) values (:avalue)
returning my_table_id as new_id, created, created_by
Can I alias these fields - Firebird supports this.
FWIW, the returned values are created by triggers on the table.
I'm using version 6.0.1 of Interbase Data Access Components.