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

2012-02-15 Thread Milan Babuskov 
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
==

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

2012-02-15 Thread Helen Borrie 


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

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

2012-02-15 Thread Elmar Haneke 

> 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

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

2012-02-14 Thread Alexandre Benson Smith 
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

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

2012-02-14 Thread nathanelrick 
hello,

i want to do something like

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

how to do this ?