| Subject | Re: [firebird-support] FB 2.1 - UPDATE OR INSERT |
|---|---|
| Author | Anderson Farias |
| Post date | 2008-05-26T14:06:25Z |
Hi,
UPDATE OR INSERT INTO MYTABLE (MYFIELD1, MYFIELD2)
VALUES (1, MYFIELD2+1)
(althoug I've never used, so not so sure) ... BTW, since you're using FB
2.1, have a look at MERGE statement on the release notes.
Regards,
Anderson Farias
> UPDATE OR INSERT (MYFIELD1, MYFIELD2) VALUES (1, MYFIELD2+1)It should be
UPDATE OR INSERT INTO MYTABLE (MYFIELD1, MYFIELD2)
VALUES (1, MYFIELD2+1)
(althoug I've never used, so not so sure) ... BTW, since you're using FB
2.1, have a look at MERGE statement on the release notes.
Regards,
Anderson Farias