i want to do something like
update or insert into mytable(ID, amount) values (123, amount + 100);
how to do this ?
Have a look at
http://www.firebirdsql.org/refdocs/langrefupd21-update-or-insert.html
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
hello,
i want to do something like
update or insert into mytable(ID, amount) values (123, amount + 100);
how to do this ?
Em 15/2/2012 04:54, nathanelrick escreveu:
hello,
i want to do something like
update or insert into mytable(ID, amount) values (123, amount + 100);
how to do this ?
:)
Pretty hard to answer anything taking into account the information you
provided