Subject | Re: [firebird-support] Re: FB 2.1 - UPDATE OR INSERT |
---|---|
Author | Fidel Viegas |
Post date | 2008-05-27T09:35:20Z |
On Tue, May 27, 2008 at 5:44 AM, dirinler <dirinler@...> wrote:
provide values like in a normal insert if you are using the statement
in DSQL.
Fidel.
>That is the syntax you use inside a stored procedure. You will have to
> myfield0 is pk here
> UPDATE OR INSERT INTO TABLO (myfield0,myfield1)
> VALUES (:F0,:F1,:F2,:F3,:F4) MATCHING (myfield0,myfield1)
provide values like in a normal insert if you are using the statement
in DSQL.
Fidel.