Helen Borrie wrote:

>
> > > update fifthpercentile set DEPRECIATION = (select sum(DEPRECIATION)
> > > from incomestatement
> > > where
> > > incomestatement.prd = :curpnum)*0.05 ) <-- missing right bracket
> > > where period = :curpnum;
> >
> >That's an odd number of right brackets, should there also be a
> >corresponding left bracket e.g.
> >
> >update fifthpercentile set DEPRECIATION = ((select sum(DEPRECIATION)
> >from incomestatement
> > where incomesattement.prd
> >= :curpnum)*0.05)
> >where period = :curpnum
>
> Correct. You must isolate the where clause of the subselect from the where clause of the update statement.
>

Anyway, tried it and got the same result.

The thing is, when I try this command interractively it works fine
(there seem to have been a number of postings recently with this type of
problem).

I guess it's time for the fine toothed comb
mutter mutter grumble

Paul