Has anyone experienced a problem updating tables running an exe, but when I run it under debug, everything is updated. I am using the Update command with the code placed in a class. I have since removed the table from the data environment and open the file directly ( using use xxx. I think it may have something to do with the update

My statement looks as follows:
where upd_str is a list of variables

select (sdataArea)
scan
scatter memo memvar
m.avg_proj = m.tw_proj
if not seek(ALLTRIM(STR(m.tw_proj)),'yrnavg','avg_proj')
insert into yrnavg from memvar
else
update yrnavg set &upd_str;
where avg_proj = m.tw_proj
endif
select (sDataArea)
endscan

Thanks,

AL Privott