--- In firebird-support@yahoogroups.com, "Anderson Farias"
<peixedragao@...> wrote:

>
> Hi Adriano,
>
> > Yes. But will not work either. You can't use MYTABLE columns

inside

> > VALUES.
>
> Thanks
>
>
> Regards,
> Anderson Farias
>

try this

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