Subject Re: [ib-support] how to replaceing values of to fields in one UPDATE
Author Paul Vinkenoog
Hi Helen,

> The syntax is just a comma-separated list of SET clauses:
>
> update MyTable
> set field1 = 'avalue',
> set field2 = 'bvalue',
> set fieldn = .................

...but don't repeat the SET keyword, or else you get an
"Invalid Token".

Let's say it was the long flight home, or maybe still dreaming of
beautiful Vienna?


Greetings,
Paul Vinkenoog

from even-more-beautiful Amsterdam :-)