Do you have table buffering enabled?
>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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05