Subject | Re: [ib-support] how to replaceing values of to fields in one UPDATE |
---|---|
Author | Helen Borrie |
Post date | 2003-05-26T00:48:31Z |
At 01:14 AM 26/05/2003 +0200, you wrote:
oh! I could have stayed in Vienna for ever...
cheers,
heLen
>Hi Helen,For sure! :-)) No sleep for > 40 hours, does something to the brain. But
>
> > 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?
oh! I could have stayed in Vienna for ever...
cheers,
heLen