Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trouble with 'replace' statement
Message
From
28/05/1999 07:57:49
 
 
To
28/05/1999 07:52:22
Jolene Dicks
Human Resources Development Canada
St. John's, Newfoundland, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00223884
Message ID:
00223886
Views:
25
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform