Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replacing in different work area
Message
From
22/03/2006 02:13:03
 
 
To
21/03/2006 18:54:21
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6
Miscellaneous
Thread ID:
01106457
Message ID:
01106518
Views:
21
If you are at EOF in the current work area, you're fine. But if you are at the "phantom record", meaning reccount()+1, that's when you will have a problem.

>I have a program with the following line
>REPLACE header.terror_inc WITH m.rbTerror + 1
>
>My current work area is not actually DWELL and it is at EOF(). I know I need to change the line to
>REPLACE terrror_inc WITH m.rbTerror +1 IN header
>
>For some reason, this code has been making the replacement for several years even when EOF() was true in the current work area. In fact, it is still working in the production version of the system. Are there any situations where the replacement can take place even when it is documented that it shouldn't?
>
>I've made a couple of very minor adjustments to the code which I wouldn't have expected to make a difference in this REPLACE statement. The only difference I can think of is that in the current version, I never move out of the current work area. In the test version, I have done a query in a new utility and then moved back into the original work area. Could that have triggered it?
>
>I have the #$%$%^ thing fixed, but I still curious why it worked all this time?
>
>Thanks to all........Rich
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform