Subject Re: [ib-support] how to replaceing values of to fields in one UPDATE
Author Helen Borrie
At 01:14 AM 26/05/2003 +0200, you wrote:
>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?

For sure! :-)) No sleep for > 40 hours, does something to the brain. But
oh! I could have stayed in Vienna for ever...

cheers,
heLen