Sorry about the subject, I forgot to add that in. I can't seem to get
anything accepted after the :counter statement. I keep getting an
illegal token ; erorr.
Hugh

--- In ib-support@y..., Aage Johansen <aagjohan@o...> wrote:
> (not a well chosen 'subject' ...)
>
>
> > UPDATE PTDEMOG
> > SET SPECIMENID = :counter;
> where ?????? <==========
> >END
> >
> >but it updates all PTDEMOG.SPECIMEN_ID fields
> >with the same SPECNO.SPECIMEN_NO value.
>
> Without a WHERE clause you have specified that all rows are to be
updated.
>
> Regards,
> Aage J.