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 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 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
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]
Date: Wed, January 18, 2012 11:55 am
To: [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
