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