Subject | Re: [firebird-support] FB 2.1 - UPDATE OR INSERT |
---|---|
Author | Adriano dos Santos Fernandes |
Post date | 2008-05-26T14:07:58Z |
Anderson Farias escreveu:
Adriano
> Hi,Yes. But will not work either. You can't use MYTABLE columns inside VALUES.
>
>> UPDATE OR INSERT (MYFIELD1, MYFIELD2) VALUES (1, MYFIELD2+1)
>
> It should be
>
> UPDATE OR INSERT INTO MYTABLE (MYFIELD1, MYFIELD2)
> VALUES (1, MYFIELD2+1)
>
Adriano