>I am trying to execute a series of simple 'replace' statements. I loop through an array which in turn does various checks and manipulations. I also have a counter which calculates a value for each record in the .dbf.
>
>The program produces the following results in a dbf:
>
> Mon Tues Wed Thur Fri Sat Sun Total
>Rec1 * * * * 4
>Rec2 * * * 3
>Rec3 * * * 0
>
>The problem is that some of the records total aren't right for some of the records. After I noticed it I suspended my program and traced through the loop. The counter variable actually contains the correct total, but when it replaces the 'total' field in the table, it remains as 0 (see Rec3).
>
>Has anyone experienced any problem such as this with replace statements. I'll take any suggestions, I am at a lost...
>
>TIA
>
>Jolene Dicks
Jolene,
Are you selected on the alias that you are performing the REPLACE? If you are on a different alias and at EOF() on that file, then the REPLACE won't error but it also won't work!
HTH
regards
Ian