Well yes.. You have to remove the ;
Such as:

SET SPECIMENID = :counter
WHERE blahblahblahblah and blah


Best regards,
Fred Wilson
SE, Bell & Howell
fred.wilson@...


-----Original Message-----
From: hughman72212 [mailto:hjohnson@...]
Sent: Monday, June 24, 2002 1:44 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: (unknown)


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.



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/