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 ==================================