>> i want to do something like >> >> update or insert into mytable(ID, amount) values (123, amount + 100); >> >> how to do this ?
At 09:22 PM 15/02/2012, Elmar Haneke wrote: >Have a look at >http://www.firebirdsql.org/refdocs/langrefupd21-update-or-insert.html Won't work for this. Use MERGE. ./heLen