Subject RE: [IBO] IB_WISQL problem (maybe) - the code
Author Kevin Stanton
What I usually do is write the SP in increments. You might start commenting
out code as well to isolate.
I have even run into the max statements a SP handle and had to break out one
SP into two.
-----Original Message-----
From: Paul Little [mailto:paul.little@...]
Sent: Thursday, April 05, 2001 9:06 AM
Subject: Re: [IBO] IB_WISQL problem (maybe) - the code

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
> >= :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

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


Yahoo! Groups Sponsor

Click Here to Find Software Faster

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]