I trace through WHILE loops ok (7.6.10.31029); the only difference is
that I turn ERROR MESSAGE 705 back on:
SET ERROR MESSAGE 705 OFF
DROP CURSOR curDepotsTemp
SET ERROR MESSAGE 705 ON
Doug
On 1/18/2012 1:30 PM, [email protected] wrote:
Karen,
Appreciate your thoughts but I think many of us use abbreviations, but
you were absolutely right in that the problem(whatever it is since I
can't see it) had absolutely nothing to do with the syntax.
I spelled everything out and the problem does not go away. I still
cannot see the code execute between the while and endwhile in a
declare cursor loop. Here is the code as corrected;
set trace on
set messages on
set error messages on
set v vdate1 date=02/08/2012
set variable vpropid int=null
set variable vSbjTrimMean currency=null
set variable vrar double=null
select RAR into vrar vi1 from timetrend
set variable vSCAPPAV currency=null
set error message 705 off
drop cursor c#1
declare c#1 cursor for select propid from SCPropdata where
scheardate=.vdate1
open c#1
fetch c#1 into vpropid vi1
while sqlcode <> 100 then
select SbjTrimMean into vSbjTrimMean vi2 from CMAmass where
propid=.vpropid
if vSbjTrimMean > 0.00 then
set variable vSCappav=(.vSbjTrimMean*.vrar)
update scpropdata set SCAPPEV=.vSbjTrimMean,SCAPPAV=.vSCappav +
where propid=.vpropid
endif
fetch c#1 into vpropid vi1
endwhile
drop cursor c#1
set trace off
set messages off
set error messages off
-------- Original Message --------
Subject: [RBASE-L] - Re: Cannot see code when trace is set to on
From: [email protected] <mailto:[email protected]>
Date: Wed, January 18, 2012 11:55 am
To: [email protected] <mailto:[email protected]> (RBASE-L Mailing
List)
Bill: I'd be willing to bet that this has _nothing_ to do with
the problem
you're seeing (I've never seen it myself). But looking at your
code below
I see some real scary-looking code abbreviations that I would
never use.
Like "the" rather than "then", "endi" for "endif", "ret" for
"return". I suppose
I can understand the "whe" for "where" but I've stopped doing that
years
ago. Do you think it's worth a try putting in the full words and
seeing
if that fixes your problem?
Karen
