We ran into that problem once and I believe it was because we had WHILEOPT turned on.
~~ Dee ext 514 From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, January 18, 2012 11:30 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Cannot see code when trace is set to on 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] 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
