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


Adriano