Subject Re: [firebird-support] Re: FB 2.1 - UPDATE OR INSERT
Author Fidel Viegas
On Tue, May 27, 2008 at 5:44 AM, dirinler <dirinler@...> wrote:

>
> myfield0 is pk here
> UPDATE OR INSERT INTO TABLO (myfield0,myfield1)
> VALUES (:F0,:F1,:F2,:F3,:F4) MATCHING (myfield0,myfield1)

That is the syntax you use inside a stored procedure. You will have to
provide values like in a normal insert if you are using the statement
in DSQL.

Fidel.