nathanelrick wrote:

> i want to do something like
>
> update or insert into mytable(ID, amount) values (123, amount + 100);
>
> how to do this ?

Use MERGE:

http://www.firebirdsql.org/refdocs/langrefupd25-merge.html

If you have an older Firebird version and still want a single SQL
command, you can use EXECUTE BLOCK as explained in

http://www.firebirdfaq.org/faq220/


--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================