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 In a message dated 1/18/2012 12:48:00 PM Central Standard Time, [email protected] writes: > while sqlcode <>100 the > select SbjTrimMean into vSbjTrimMean vi2 fro CMAmass whe propid=.vpropid > if vSbjTrimMean >0.00 the > set v vSCappav=(.vSbjTrimMean*.vrar) > update scpropdata set SCAPPEV=.vSbjTrimMean,SCAPPAV=.vSCappav + > whe propid=.vpropid > endi > fetch c#1 into vpropid vi1 > endwhile > drop cursor c#1 > set trace off > ret > >
