[firebird-support] what the most efficient way to do update or insert with value ?

[nathanelrick]

hello,

i want to do something like

update or insert into mytable(ID, amount) values (123, amount + 100);

how to do this ?